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!
string contains new line character (LF/CR)
Moderators: chulett, rschirm, roy
You can use the command to remove all occurrences of CR and LF in your string.
Code: Select all
convert(char(10):char(13),'',In.ColumnName)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>