SPLIT DATA FROM EXCEL ONE CELL TO MULTIPLE CELLS USING ALTERYX

Puneet13

Hi I'm not able to split using tools can any body help me to get spilt in different cells in excel "Offshore Audit count- 19", "Total Error -0", "Financial Errors - 0", and "Procedural Errors- 0" from the below list. The entire list in one cell in Excel. I want to split it using Alteryx. Also in the snapshot currently data is showing in Excel file in one file.

Data.PNG

JamesCharnley

Hi @Puneet13,

I'm not 100% sure this is what you're asking for, but the mentioned split is possible using Regex. I'm not a RegEx expert by any means but I can seem to get what you need with: (.*?)\((.*?)(F.*?)CPA.*?(P.*?)P.*

It should be too hard to make any formatting changes you might need.

Let me know if that does the job.

James

SplitCountsRegex.yxmd