Parse concatenated Sting to columns based off of multiple delimiters

Question

All,

I have a form that im pulling from a database. The form has multiple questions, and all of the questions/responses are output into one cell.  Is there an easy to break out the data into columns, based off of multiple delimiters?

Here is what  the input is

This is the output I want

Alteryx Help String to Column delimiters.yxmd

markcurry · Accepted Answer

Hi @LAS1

See attached, hopefully that does the trick for you....

markcurry · Accepted Answer

Hi @LAS1 , see the attached workflow.  Because your records are repeating every 43 records, I've added a response number field (1-5) and a Question ID (1-43), but you don't need the Question ID.....