Searches for regular expression in string beginning at offset, and if it finds a match, splits string into three substrings. The connector pane displays the default data types for this polymorphic function. Refer to example strings for more information about the Match Pattern function.
![]() |
string is the input string to search. |
![]() |
regular expression is the pattern searched in string. If the function does not find regular expression, match substring is empty, before substring is the entire string, after substring is empty, and offset past match is 1. You can use special characters in regular expression. |
![]() |
offset is the starting position and must be numeric. The offset of the first character in the string is 0. If unwired or if less than 0, the default is 0. |
![]() |
before substring returns a string containing all the characters before the match. |
![]() |
match substring is the matched string. |
![]() |
after substring contains all characters following the matched pattern. |
![]() |
offset past match is the index in string of the first character of after substring and is set to -1 if no match is found. |