 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Oct 2009 @ 12:00:43 GMT
| Subj: | | Re: Load a file with new line character in data |
| |
| From: | | Victor Sokovin |
| | I am trying to load a CSV file using Mload from unix for 3 columns in below format, which has new line character in the data (second
row).. | |
I don't think it is possible with text formats. Linefeed has a very special meaning: record separator, and it takes preference over all field
descriptions.
If you don't have too many exceptions like this you could consider converting them into some special character in the file and then update the
records in the target table and change that special character back to linefeed. Perhaps there is a trick do the conversion in the ML script but I
am not sure about it.
Victor
| |
