Incomplete load of CSV files

[sangland2]

When loading a CSV file using:(txt, codepage is 1252, embedded labels, delimiter is ',', msq)  the load stops before it reaches the end of the file. There is no error but not all the data is loaded. This is because text fields in the file have not been quoted, as they should, so the number of fields being loaded is different when it hits this line. An error should be thrown, surely? 

[Frank_Hartmann]

did you look in my first post?

please change this line in your script:

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

to

(txt, codepage is 1252, embedded labels, delimiter is ',')

[sangland2]

The customerOrderNomber column has a single " character in line 33446 and again in 37154. Rows between are not loaded.