Dynamically Parse and Normalize data

[mercurial_maverick]

Hello all,

I've an excel file that has Material# and Item Description in column A & B. I need to parse and retrieve refrigerant type and cylinder size from column B. The expected output is show in column C,D, F & G. For row 2, there is no cylinder size in column B and hence this need to be retrieved from column A (30 in BANK30R22W). Column G needs to be numerical and not a string. Please let me know how to achieve this.

[clmc9601]

Hi @mercurial_maverick,

Will this work for you? I used a variety of regex expressions to parse the item description column. Alteryx has a lot of great resources on regex if you're interested in learning more!

 

[mercurial_maverick]

@clmc9601 Could you please send just the workflow alone and not as a packaged file?

[clmc9601 · Accepted solution]

Sure, here you go:

[mercurial_maverick]

@clmc9601 That worked, thank you!