01-10-22 06:26 PM
Answered! Go to Answer.
03-10-22 02:11 PM
Further to what @PvD_SE had said about using Regex, you can use the "Test Regex Match" action in BP's "Utility - Strings" VBO. You can use a regex pattern of:
"^[a-zA-Z]{3}[0-9]{7}$"
This will take care of both your length testing and character matching. The breakdown of the pattern is:
^ - start of the line
[a-zA-Z] - match any letter
{3} - match three of the previous specified characters
[0-9] - match any numbers (before anybody says anything, no, "\d" does not always mean the same as "[0-9]" in .Net)
{7} - match seven of the previous specified characters
$ - end of line
------------------------------
Micheal Charron03-10-22 06:27 AM
03-10-22 07:05 AM
03-10-22 02:11 PM
Further to what @PvD_SE had said about using Regex, you can use the "Test Regex Match" action in BP's "Utility - Strings" VBO. You can use a regex pattern of:
"^[a-zA-Z]{3}[0-9]{7}$"
This will take care of both your length testing and character matching. The breakdown of the pattern is:
^ - start of the line
[a-zA-Z] - match any letter
{3} - match three of the previous specified characters
[0-9] - match any numbers (before anybody says anything, no, "\d" does not always mean the same as "[0-9]" in .Net)
{7} - match seven of the previous specified characters
$ - end of line
------------------------------
Micheal Charron03-10-22 04:10 PM
03-10-22 10:35 PM