Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

ReGEX Character Length Parsing

Damon-James
5 - Atom

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. 

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

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

Damon-James
5 - Atom

Thank you! This did the trick.

Labels
Top Solution Authors