|
|
Can you use regular expressions for string matching?
Look for the following formula to return true in each case.
To check if a character is alphanumeric...
@Matches(Char; "{A-z}")
To check for "a" or "b" or "c" ...
@Matches(Char; "{a-c}")
To check for all upper case alphanumeric plus the letters "a" or "b" or "c" and "d" ...
@Matches(Char; "{A-Za-d}")
To check for $321,000 or $321.000 but not $321.00 or $321,000- ...
@Matches(Dollar; "{$}{0-9}{0-9}{0-9}{,.}{0-9}{0-9}{0-9}")
To check for US long distance phone number...
@If(
@Matches(PhoneNum; "{0-9}{0-9}{0-9}-{0-9}{0-9}{0-9}-{0-9}{0-9}{0-9}{0-9}");
@Success;
@Failure("The Phone number must be in the format \"xxx-xxx-xxxx\"")
)
To check for social security ...
@Matches(SSNum;"{0-9}{0-9}{0-9}-{0-9}{0-9}-{0-9}{0-9}{0-9}{0-9}")