Phil Parkin (1/12/2014)
Columns are not missing here . I have 5 column here ,looks like this.
[Just a sample data ,but this is the format we load]
col1 col2 col3 col4 col5
USD1542.5214536xxxx
1542.5214536
EUR 1542.5214536xxxx
What would this sample data look like if there were no problems with delimiters?
I am getting output as like below when i do bcp command on unix.
C1 C2 C3 C4 C5
<NULL>USD 1542.5214536xxxx
<NULL> <NULL> 1542.5214536EUR|1542.52|14536|xxxx