Removing New Line in Datatable

Hi,

The second column of my data Table looks something like this:

Col2
14:00

USD ISM Composite (JUL)

22:45

NZD Unemployment Rate (2Q)

Desired output:

Col2
14:00 USD ISM Composite (JUL)

22:45 NZD Unemployment Rate (2Q)

I am thinking of removing the new line, how can i do it?

Thanks

@bhe98

Try like this:

               row("Col2")  = row("Col2").ToString.Replace(vbCrLf, "")

Hi,

Thanks for your help.

What I did was row(“col2”) = row(“col2”).ToString.Replace(Environment.NewLine,“”)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.