Jump to content

csv quote import number decimal separator ambiguity with field separator


r2d2r01
 Share

Recommended Posts

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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...