Hi All,
Has anyone come across where flat file uploads cuts out the last 1 or 2 columns from the upload.
This happens in the preview and in the actual load.
The data separators(,) and the Escape sign (") are OK
This are sample lines below:
"60 ","105906 ","A","253215 ","2005052700000000","516007 ",".TonyA ","1.17 ","0.20 ","2005050600000000","7 ","1 "
"102 ","42577 ","A","560194 ","2005070400000000","825293 ","A.HARCOURT ","23.95 ","4.19 ","2005062300000000","8 ","56 "
"149 ","103179 ","A","254010 ","2005020900000000","208864 ","Paul Glew ","2.16 ","0.38 ","2004121300000000","9 ","1 "
It only loads up to the column with 0.20,4.19,0.38 and cuts it out from the date onwards (3 last columns).
Anybody seen this???