I need to load some data using SQLLDR. It is a .txt file with tab delimited data and the data file may contain tabs or spaces within column data. Cld anyone suggest how it can be loaded? Thanks.
EmpID EmpName EmpAdd1 EmpAdd2
1000 SAM KING SUITE 5 JOHNSON CITY TX
where EmpId = 1000
EmpName SAM KING(tab/space separated)
EmpAdd1 SUITE 5 JOHNSON CITY (tab/space separated)
Emp Add2 TX
What it is currently doing is loading 'SAM' in the EmpName and 'KING' in the EmpAdd1 which is what I dont want. Pls suggest.