05-04-2020 06:01 PM
I am trying to create an expression for the Match Pattern function. The pattern I want to match is: starts with any single capital letter, followed by any number of digits 0 to 9. There cannot be any other characters following the last digit.
Acceptable:
A1
B22
C333
Filter out:
A
AA
ABC
ABC123
aaa456
ABC123abc
AAA456def
B789ghi
C1J
D55:6
a123
This is what I have so far "^[B,D,E][0-9]" however it allows characters following the last digit.
I've read that the Match Regular Expression is slower than the Match Pattern function. I have this in a loop so would like to use the Match Pattern function function if possible.
Thanks!
Solved! Go to Solution.
05-04-2020 09:32 PM
Try ^[A-Z][0-9]+$