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 |
Solved! Go to Solution.
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.
Simply use Text to Column Tool
I hope that helps
Fantastic, thank you so much!
Fantastic, thank you so much.
Thank you!
@msyosd
Glad to help and thank you for the accept mark