Unfortunately that's currently not possible. If the currency symbol had been "$" instead of "USD" it would probably have worked as the code is hardwired to ignore that value.
The only alternative I can suggest is to preprocess your CSV file to add a column with the amount without currency symbol. Regards, Geert Op donderdag 12 mei 2022 07:12:00 CEST schreef [email protected]: > @Geert, > > You are correct, "10 550,50" imports fine. > However my CSV file also has a currency symbol at the end (e.g. "10 550,50 > USD"), and the imported numbers are then incorrect. > I wish that Gnucash would ignore the text in the amounts! I assume that > there is no option for this? > > > > From: Geert Janssens [mailto:[email protected]] > Sent: 11 May, 2022 02:27 > To: [email protected]; [email protected] > Cc: [email protected] > Subject: Re: [GNC] Setting Currency Format when importing from CSV? > > > > I believe gnucash only cares about the decimal point separator and ignores > the thousands separator. So for your example selecting "Comma" as currency > format should work. At least it does in a quick test I just performed. > > > > Regards, > > > > Geert > > Op dinsdag 10 mei 2022 06:43:32 CEST schreef [email protected]: > > The CSV Transaction Importer only has 3 options for currency format: > Locale, > > > Comma and Period. Is there some way to change it to something else? > > > > > > > > > > > > > > > > For example in the CSV file, I have "10 550,50" which would translate to > > > > "10,500.50" (in the US). Can I make GnuCash translate this properly? > > > > > > > > _______________________________________________ > > > > gnucash-user mailing list > > > > [email protected] > > > > To update your subscription preferences or to unsubscribe: > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > > If you are using Nabble or Gmane, please see > > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
