Hi,
Thanks for the response.

let me more clear what type of data file I have. The data file is in regular Excell sheet/file with file extension .xls e.g(myfile.xls) and terminated by by '|' see below

1ooo|Item1|345.90
2000|Item2|100.00

The above data has saved in 5 cell
1000 = 1 cell
| = 1 cell
Item1 = 1 cell
| = 1 cell
345.90 = 1 cell

now sql*loader with FIELDS TERMINATED BY '|'

Hope this is clear.

Thanks in advance