This cell has embedded newlines and truncated characters

[BautistaC888]

Hello,

I have an input that look like this:

And i need to split it into rows to work on the data.

Thank you.

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

You can configure the text to column tool to split on newline into rows. Refer the highlighted options.

Hope this helps : )

[OllieClarke · Accepted solution]

Hi @BautistaC888 

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

[Jonny · Accepted solution]

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 

[Jonny]

now with the workflow 🙂