Skip to Content
0
Former Member
Oct 25, 2005 at 04:08 PM

Flat File Load Problem

30 Views

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???