Hello All,
Through research and browsing the community I have not been able to effectively parse out a specific character length within a line. My use case relates to VIN numbers being received through email. We want to parse out 17 characters ie. the length of the VIN from the subject line of the email; however the VIN # placement could be in the front of the text or behind the text. The trouble I am running into is the characters are pulling in blanks and with VIN #'s there will be letters within the digits. I have not been able to figure out how to use ReGex to only look at the length of characters within a line and return a generic 17 count separated by spaces. I have attached my current workflow for reference.
Solved! Go to Solution.
I can tell you that for me has worked like this:
(\s?)(\d.{16})(\s?)
I know its not perfect but will keep looking anyways
Thank you! This did the trick.
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
5 |