How can i convert it?

[170290064 (Eyüp Hasan Akbaba)]

From this

To this

There are hundreds of it in the excel sheet. Any ideas for a quick way ???

[lrtetala (Lakshman Reddy)]

Hi @170290064

Try this

Vare.ReplaceLineEndings(" ")

Regards,

[supriya117 (Supriya Allada)]

Hi @170290064

Try:
CurrentRow(“colName”).Replace(Environment.NewLine, “”)

[lrtetala (Lakshman Reddy)]

@170290064

Please try this

How can i convert it?

Hi @170290064 Try this Vare.ReplaceLineEndings(" ") [image] Regards,

If you got the solution please mark it as solution to close the thread.

Regards,

[Vikas_M]

Hey @170290064 ,

String.Join(“”,yoo.Split(Environment.NewLine.ToCharArray))
Replace yoo with your variable name and
Try this

[170290064 (Eyüp Hasan Akbaba)]

It worked thanks a lot

[170290064 (Eyüp Hasan Akbaba)]

May i ask one more question ?

I want to write in the excel sheet and change the indicating columns like in the following.

What shoud i do after that ?

[lrtetala (Lakshman Reddy)]

@170290064
In for each take assign activity
CurrentRow(“YourColumn”).ToString=CurrentRow(“YourColumn”).ToString.ReplaceLineEndings(" ")

[lrtetala (Lakshman Reddy)]

After that use write range workbook activity

[170290064 (Eyüp Hasan Akbaba)]

originalDate.ReplaceLineEndings("")

This one works better