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.

[Puneet13]

Anyone help on the above query.

[Emmanuel_G]

@Puneet13  Can you please provide a dummy excel file with some rows and desired output ?

[JamesCharnley · Accepted solution]

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

[Puneet13]

It's Working, thanks a ton James.