Parsing string data separated by commas

[arundaka02]

Hi everyone

I want to parse string data separated by a comma only from a survey response. Examples below: 

I would like to learn how to use the following tools or standard frameworks (survey response)	Tool or standard framework 1 (desired output)	Tool or standard framework 2 (desired output)	Tool or standard framework 3 (desired output)	Tool or standard framework 4 (desired output)
Example1, Example2, Example3, Example4	Example1	Example2	Example3	Example4
Example1, Example2, Example 3	Example1	Example2	Example3
Example1	Example1

Required criteria:

• The number of responses in the survey response column can range from none to 10+
• Each separation needs to go into a new column, depicted in 'desired outcomes' columns above
• Responses will always be separated by a comma only
• Trailing spaces will need to be removed from each separation 
• I have x4 columns in my dataset that the above needs applying to

I've tried using the Text to Columns tool but this doesn't appear to account for multiple responses very well and looks at one column only. 

Can anyone help?

Thanks

KA

[Jonathan-Sherman · Accepted solution]

Hi @arundaka02,

Yes it would be possible, since you're wanting to split dynamically i'd split to rows first and pivot the data back after!

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[DavidP]

Hi @arundaka02 

Here's how I would do it

[ImadZidan]

Hello @arundaka02 ,

I have given it a go. The workflow is specific for four columns but generic in terms of what each column has.

Its an idea.

Hope it helps

[arundaka02]

Thanks @Jonathan-Sherman this has worked very well. 

You've been a great help today!