How do you remove carriage return character in datatable

491114473 · January 6, 2021, 6:42am

Some data in column 2 of EXCEL contain carriage return characters. How to handle this?

Lahiru.Fernando · January 6, 2021, 6:52am

You can loop through the datatable and use a command as follows to update…

origString.Replace(vbCr, "").Replace(vbLf, "")

Or

StringName.Replace(stringName,chr(13),"")

Let know whether these work for you…

491114473 · January 6, 2021, 7:07am

Thanks~
Cheers!!

system · January 9, 2021, 7:07am

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