Regular Expression Pattern Matching Using !Match - Revision history

Johno: /* Regular Expression Pattern Matching */

2023-02-17T17:01:26Z

‎Regular Expression Pattern Matching

2023-01-19T23:33:16Z

‎Regular Expression Pattern Matching

2023-01-19T23:17:18Z

‎Regular Expression Pattern Matching

2023-01-19T23:16:43Z

‎Regular Expression Pattern Matching

2023-01-19T23:13:31Z

‎Regular Expression Pattern Matching

2023-01-19T23:12:30Z

‎Regular Expression Pattern Matching

2023-01-19T23:10:48Z

‎Regular Expression Pattern Matching

2023-01-19T23:09:57Z

2023-01-19T23:09:12Z

2023-01-19T23:07:41Z

‎Regular Expression Pattern Matching

@@ Line 11: / Line 11: @@
 The above example will not find all invalid email addresses, but it will find those that don't match the pattern.  The equals zero, means that the pattern was not matched.  See below for an explanation of this pattern:
      {| class="wikitable" style="border-spacing: 2,2,2,2;"
-      |Pattern ||Explanation of pattern
+      |'''Pattern''' ||'''Explanation of pattern'''
       |-
       | ^ || Start the match at the beginning of the string

@@ Line 7: / Line 7: @@
 An example of using !match to find invalid email addresses is shown below:
-  !match(!trim(MEMBER-FILE.E-MAIL), "^[^ @]+@[^ @\.]+\.[^ @\.]+$") = 0 AND MEMBER-FILE.E-MAIL <> " "
+  !match(!trim(MEMBER-FILE.E-MAIL), "^[^ @]+@[a-zA-Z0-9-]{1,63}\.[a-zA-Z]{2,6}$") = 0 AND MEMBER-FILE.E-MAIL <> " "
 The above example will not find all invalid email addresses, but it will find those that don't match the pattern.  The equals zero, means that the pattern was not matched.  See below for an explanation of this pattern:
@@ Line 19: / Line 19: @@
       | @ || Match the @ character
       |-
-      | [^ @\.]+ || Match at least one (+) character that is not a blank, the @ character, or a period.
+      | [a-zA-Z0-9-]{1,63} || Match the domain name. Valid characters are letters, digits and the hyphen. Between 1 and 63 characters long.
       |-
-      | \. || Match a period (dot).
+      | \. || Match a period (dot). Because the dot has special meaning (any character), it must be escaped by the backslash.
       |-
-      | [^ @\.]+ || Match at least one (+) character that is not a blank, the @ character, or a period.
+      | [a-zA-Z]{2,6} || Match the TLD. Only letters are valid. Between 2 and 6 characters long.
       |-
       | $ || Match until the end of the string. The !trim is needed to ensure trailing blanks are ignored.

@@ Line 1: / Line 1: @@
 === Regular Expression Pattern Matching ===
-The AskPlus !match function uses the Perl Compatible Regular Expression (PCRE) engine to perform patching. If a match is found, the function returns the position of the match in the string. If no match is found, zero is returned. The basic syntax of !match is:
+The AskPlus !match function uses the Perl Compatible Regular Expression (PCRE) engine to perform pattern matching. If a match is found, the function returns the position of the match in the string. If no match is found, zero is returned. The basic syntax of !match is:
   !match(string, pattern)

← Older revision		Revision as of 23:16, 19 January 2023
Line 28:		Line 28:
	\|}		\|}

−	An excellent site for testing regular expressions can be found [https://www.regextester.com here]. Remember to switch the matching engine from Javascript to PCRE.	+	:*An excellent site for testing regular expressions can be found [https://www.regextester.com here]. Remember to switch the matching engine from Javascript to PCRE.
		+	:*There are many PCRE resources available online. This [https://www.debuggex.com/cheatsheet/regex/pcre cheatsheet] is very handy.

← Older revision		Revision as of 23:13, 19 January 2023
Line 28:		Line 28:
	\|}		\|}

−	An excellent site for testing regular expressions can be found here. Remember to switch the matching engine from Javascript to PCRE.	+	An excellent site for testing regular expressions can be found [https://www.regextester.com here]. Remember to switch the matching engine from Javascript to PCRE.

← Older revision		Revision as of 23:12, 19 January 2023
Line 27:		Line 27:
	\| $ \|\| Match until the end of the string. The !trim is needed to ensure trailing blanks are ignored.		\| $ \|\| Match until the end of the string. The !trim is needed to ensure trailing blanks are ignored.
	\|}		\|}
		+
		+	An excellent site for testing regular expressions can be found here. Remember to switch the matching engine from Javascript to PCRE.

@@ Line 15: / Line 15: @@
       | ^ || Start the match at the beginning of the string
       |-
-      | [^ ]+ || Match at least one (+) character that is not a blank or the @ character ([^ @] is a negated character class)
+      | [^ @]+ || Match at least one (+) character that is not a blank or the @ character ([^ @] is a negated character class)
       |-
       | @ || Match the @ character