[Help] How to text to columns by indent

[msyosd]

Hi Alteryx Experts,

I would like to see your advice on splitting the first row and second row in the same cell (kind of text to columns by indent) like the below.

I really appreciate any help you can provide.

Before	After1	After2
60G70 ABC	60G70	ABC
60DD0 XYZ	60DD0	XYZ
100 Financial Statement	100	Financial Statement

[BrandonB]

can you try using \n as a delimiter? It looks like this is a new line or carriage return you are referring to. If so, this should take care of it. 

[Qiu · Accepted solution]

@msyosd 
Just provide a quick sample same as suggested by @BrandonB 

[Akash__on]

Simply use Text to Column Tool

1. use \n i.e new line as a delimiters
2. set no. of coloumns to 2 for now (as we know the data)
3. Output can be seen in the as New1 and New2

I hope that helps

[msyosd]

Fantastic, thank you so much!

[msyosd]

Fantastic, thank you so much.

[msyosd]

Thank you!

[Qiu]

@msyosd 
Glad to help and thank you for the accept mark