Regex match

Supported in: Batch, Faster, Streaming

Matches an expression against a regular expression. Regular expression must match the whole string.

Expression categories: Regex, String

Declared arguments

• Expression: The expression to match against the regular expression.
  Expression<String>
• Regex: The regular expression to match against.
  Expression<String>

Output type: Boolean

Examples

Example 1: Base case

Description: Regex must match the entire string

Argument values:

• Expression: (
• Regex: abc

Output: false

---

Example 2: Base case

Description: Regex must match the entire string

Argument values:

• Expression: abcdefg
• Regex: abc

Output: false

---

Example 3: Base case

Description: You can match regex patterns

Argument values:

• Expression: abcdefg
• Regex: abc?d.+

Output: true

---

Example 4: Base case

Description: Regex patterns sometimes don't match input strings

Argument values:

• Expression: abdefg
• Regex: ab?d.*

Output: true

---

Example 5: Null case (ANSI mode on)

Description: Null patterns propagate to null

Argument values:

• Expression: foo
• Regex: null

Output: null

---

Example 6: Null case (ANSI mode on)

Description: Null columns propagate to null

Argument values:

• Expression: null
• Regex: ab?d.*

Output: null

---

Example 7: Null case (ANSI mode on)

Argument values:

• Expression: foo
• Regex: pattern

---

Example 8: Null case (ANSI mode off)

Description: Null pattern do not match

Argument values:

• Expression: foo
• Regex: null

Output: false

---

Example 9: Null case (ANSI mode off)

Description: Null columns do not match

Argument values:

• Expression: null
• Regex: ab?d.*

Output: false

---

Example 10: Null case (ANSI mode off)

Argument values:

• Expression: foo
• Regex: pattern

---