csv quote import number decimal separator ambiguity with field separator

[r2d2r01]

Hi when i try to import file from csv (comma separator) I have a pb with number which has format 707,70€which  is parsed as  70770,00€ (oups).

If i try to change in settings decimal character from ',' by '.' this one impact only view and not value imported.

How I can ask to parser to make difference from "field1, field2, field3, number,dec, field4, etc..." where "number,dec" is ONE value 707,11€ and NOT 2 VALUES

Thanks for helping

Frederic

 

[r2d2r01]

Pb resolved by changing decimal separator comma (',') by dot ('.')