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: IdqualitypricerateXDFE123123 234 10.23 45.12 0.35%DKSL1231247850.25% 0.45% 0.21% SDALF456145 12456 145 47.21 14725 147.23 0.21%ASDFLZ12341234570.23% Output: IdqualitypricerateXDFE123234 45.12 0.35%DKSL1231247850.21% SDALF456145 147.23 0.21%ASDFLZ12341234570.23%

How to split row by newline

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:

Output:

Developer

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

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!

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

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

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

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

yes of course 😅 glad that this helped!