string contains new line character (LF/CR)

[fyaqq]

In the oracle table there is a new line character in a field of a row whose type is varchar(30).
First I use oracle stage ---> sequential File, no problem at all.
Later I need to read the sequential file back to another oracle table, b/c of the new line character, all the following records got missed up.

Is there anyway to get rid of the annoying LF/CR within a string?

BTW, the string contains all chinese characters.

Thank you very much!

[kris007]

Is LF/CR at the end of the string or within the string? On the columns tab in the sequential stage select the attribute "Contains Terminators" to Yes in your first job and in your second job. That should take care of the error. If not come back

[ArndW]

You can use the

Code: Select all

convert(char(10):char(13),'',In.ColumnName)

command to remove all occurrences of CR and LF in your string.