| Problem with TAB field terminators [message #133401] |
Thu, 18 August 2005 21:03 |
damienlynch
Messages: 3
Registered: August 2005
Location: Canberra, Australia
|
Junior Member |
|
|
I have an input file with fields terminated by tabs (0x'09') and optionally enclosed by double quotes. The records are delimited by newlines and the quote enclosed fields may also contain newlines. I am trying to read this file as an external table using Oracle 9.2.
If I have any null fields (i.e. two or more tabs together), Oracle ignores these fields because it skips over whitespace (which includes my TAB terminators) looking for the first enclosing quote.
I thought I had a workaround by reading in the enclosing quotes as part of the fields and dropping them before inserting into the database. But now I have some sample data with newlines in the quoted fields which are ending my records too soon.
Is there any way of making Oracle 1) not skip whitespace when looking for a new field or 2) not consider a tab as whitespace?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
