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.
Solved! Go to Solution.
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!
@clmc9601 Could you please send just the workflow alone and not as a packaged file?
@clmc9601 That worked, thank you!