Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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