How to remove Line Feed (LF) characters from a string in BODS

[Former Member]

Hello,

I have a string in excel that seem to have a line feed characters. When I do substr(string,1,80) I have an error in some lines. Is it possible to removed all LF characters with : or some other delimiter and continue to process the data without error?

Any ideas?

Thank you,

Arthur.

[mageshwaran_subramanian · Accepted solution]

replace_substr (string , char(10) , '') should remove the Line feed

Use char(13) to remove the carriage return.