SQL Loader - new line character [message #69031] |
Wed, 17 October 2001 11:01 |
Chayan
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
The legacy email history data is imported into a text file. The body of the email has new line characters. But, when I am using SQL Loader, it is recognizing each new line character as a new record and splitting up each record.
How I can separate the records and keep the email body intact? Is there any special syntax that I can use to specify new line character in SQL Loader? How can I override the default end of record, which is the new line character?
Thanks!
----------------------------------------------------------------------
|
|
|
Re: SQL Loader - new line character [message #69063 is a reply to message #69031] |
Tue, 23 October 2001 08:12 |
Naren
Messages: 8 Registered: October 2001
|
Junior Member |
|
|
Hi Chayan,
I just saw your posting. May be you have figured out a way of doing it. If not, then here it is.
By default, it uses newline as the terminator string. If you want to override it, specify a hex-string as your terminator for the record. For example
control file:
load data
infile 'filename.dat' "str X'7c0a'"
The above hex-string X'7c0a' translates to '|' followed by 'n'
So, find out the hex-string for whatever terminator you want to use.
Hope it helps!
naren
----------------------------------------------------------------------
|
|
|