Function Index

RegexpMatch

Returns true if a string matches a regular expression.

Usage

RegexpMatch(<string>,<pattern>)

string (required) The string to search.

pattern (required) The pattern to match within the subject.

NOTE: When the regular expression you want to use contains a slash, quotation or other special character, you will need to use a slash (/) to escape the special character. Regexp can vary based on the databases. Check the documentation of the database you use to find the correct syntax.

Examples

RegexpMatch("277 Main St", "[0-9]+ Main")
  • Returns true.

More About

Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”