Tab-delimited Datafiles in Control Files

[Tracy]

Hi,
I hope this is a relatively easy question, I just can't find the answer in my documentation.

I have a file that is tab delimited that I need to load with SQLLoader. However, so of the fields are text fields with more than 1 word (thus, I can't terminate by whitespace). Any idea how I can handle this?

Thanks in Advance,
Tracy

[pipo]

just replace tabs with ';' if you are not sure, but if tabs only appear between fields, you should not have any problem to import this file

[marist89]

You can setup the tab character as the delimiter in your sqlldr control file. The syntax is something like:
delimited by X'the_hex_number_that_represents_tab'