Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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