Help with Text to columns - repetitive delimiter

[spamarthy]

Hi,

I am new to Alteryx and need help with the below scenario where the data has successive delimiters. I have data in one cell delimited by many underscores (40 to be precise) that I need to be put in other columns.

Data in cell:

abc

________________________________________

date

text_filter

________________________________________

date2

text_filter2

How I want the output:

column1 | column2 | column3

abc        | date        | date2

              |  text_filter| text_filter2

Thanks in advance!

[benakesh]

Hi @spamarthy ,

Can you attach  file with sample data ?

[jrgo · Accepted solution]

Hi @spamarthy 

See if this solution helps you out... note that when looking at the results in an Alteryx Browse, it only shows the first line, but if you look at the cell using the "Cell Viewer", you'll see that it contains the remaining value on a new line as you specified in the Expected Output in the sample file.

Jimmy
Teknion Data Solutions

[benakesh · Accepted solution]

Hi @spamarthy ,

This is another option  similar to @jrgo's solution .

[spamarthy]

Thank you @Jrgo, it is what I was looking for!

[spamarthy]

Thank you @Benakesh your solution worked as well!