Hello,
I have an input that look like this:
And i need to split it into rows to work on the data.
Thank you.
Solved! Go to Solution.
You can configure the text to column tool to split on newline into rows. Refer the highlighted options.
Hope this helps : )
If you connect your data to a text to columns tool, and split to rows on delimiter '\n' then you should be able to work with it
hope that helps,
Ollie
Hi Bautista,
I built this workflow:
I noted you have two sets of numbers, with 8 digits and 9 digits. not knowing how important they are I assumed they mean something and for some reason are not in the same sequence.
see attached, hope it helps/
cheers!
Jonny