How to split row by newline

[Sshasnk]

Hi I have a dataset wherein a cell I have multiple values in newline but I have to pick the last value example below

If you will see in quantity last value was 234 and in price 45.12 but in rate there was no value in next line so I left

Input:

Id	quality	price	rate
XDFE123	123 234	10.23 45.12	0.35%
DKSL123	124	785	0.25% 0.45% 0.21%
SDALF456	145 12456 145	47.21 14725 147.23	0.21%
ASDFLZ1234	123	457	0.23%

Output:

Id	quality	price	rate
XDFE123	234	45.12	0.35%
DKSL123	124	785	0.21%
SDALF456	145	147.23	0.21%
ASDFLZ1234	123	457	0.23%

[Emil_Kos]

Hi,

You need to use text to column and pick /n as a delimiter.

I have prepared a workflow as an example. 

Please mark my post as a solution if this was helpful!

[Sshasnk]

@Emil_Kos  I think you have pasted the data wrong in input text

[phottovy · Accepted solution]

Try the attached workflow and see if it gives you what you need.

[Amin]

Hi @Emil_Kos , you mean \n instead of /n.

Tried your solution and worked on a problem I was trying to solve! Thanks!

[Emil_Kos]

Hi @Amin,

yes of course 😅 glad that this helped!