Help with Text to columns - repetitive delimiter

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!

Help

Accepted answers

jrgo

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.