sql loader tab delimited file

[mghafoori]

Hello:
I am trying to load a tab delimited file using sql loader. I know sql loader looks for WHITESPACES as a delimiter, but since none of my fileds are enclosed in any character, then as soon as it finds a space it tries to inser into next field which is too large and then i get errors. Is there a way to instruct sql loader to look specifically for TAB and ignore other whitespaces. One solution would be to enclose all fields in a specific character, but I have received the file as is and can not modify the extract. any help?

 

[karluk]

It works for me if I specify

fields terminated by ' '

where the tab character is inside the quotes. This will correctly load embedded spaces but break on tabs.