How to remove empty lines from a cell in datatable?

studio

#1

My datatable contains 3 columns. The cells in first column has data in following format:
line1

line2

line3

I want to remove all the empty lines and store it in the same cell. Output should be like this:
Line1
Line2
Line3

How do I do this?


#2

Try to use filter data table activity or else you can apply for each loop on the datatable and on apply if condition in it that if the current value is not empty string same should be copied to a new datatable


#3

Hello @shrutika

Please refer to this workflow i created for you. This might help you :slight_smile:

Excel_Operations (1).xaml (17.1 KB)

Let me know if it helps :slight_smile:


#4

This removes all the spaces in the cell. I need to remove only the empty lines.