| sql loader multiple lines [message #74133] |
Fri, 17 September 2004 03:28  |
Jolanda
Messages: 68
Registered: September 2004
|
Member |
|
|
I have a flat file with a lot of record, which is tab delimited. Some of the records fit on 1 line. With long comments a carriage return is used, However, " is used at the beginning and end of the string (comment string).
a record looks likes this:
111 [[tab]] more info [[tab]] "this is a text field"
231 [[tab]] again info [[tab]] "this is still a [[Carriage Return]]
a text field"
Now i want to load this file into the database with SQL loader. Is it possible to give more delimiters in just 1 control file?
any other solution?
thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
