How to replace manual line break symbol to -- in a datatable


#1

hi,

I’m trying to replace a manual line break symbol ^I in my data table with –

i appreciate if you can provide assistance on how to do this in my workflow.

thanks,


#2

Hi Jay, could you share your workflow for better understanding…


#3

replace the following

((CHR(13))+(CHR(10)))

so

DataTableVarName(1)(2).ToString.Replace(((CHR(13))+(CHR(10))),(""))

Will replace newline character in row 1 column 2 in datatable named DataTableVarName