Hello.
This is a general issue with the CSV parser out there today. Not CSV files have data which is possible to delimit using comma.
I've created a new version of collections manipulation, which include CSV 2 collection and the other way around with a custom delimiter.
Send me an email if you would like a copy. It's also much faster than the original and widely used.
*****************
Hello Tgundhus,
I've just read your reply about your new version of collections manipulation which include CSV 2 collection and I'm interested by a copy.
I use the version 5 of BP.
Additional information, in the CSV file the separator is ; but a coma is already in the specific amount (e.a. 1st line the amount is
7.993,14)
Dossier;Provision facturée;Montant trf. (62.01, 68.01);Recettes (20.01);Section;Code dom.;
867;
7.993,14;5.736,06;2.211,95;USVBLA ;0;
11134;6.199,88;5.226,55;766,85;USAMID ;0;
12829;3.334,97;2.346,84;987,13;USWZWI ;0;
12989;2.457,07;2.291,72;164,51;USFERK ;0;
13226;4.068,50;1.968,31;737,47;USVBLA ;0;
13976;2.056,91;679,31;-167,74;USPLKL ;0;
14975;4.154,70;0;1.244,00;USEBOA ;0;
15173;12.632,89;9.579,44;3.053,44;USMVDW ;0;
16404;3.603,60;0;421,77;USMVDW ;0;
Many thanks in advance for your reply.
Kind regards,
Eric