[GNC] Setting Currency Format when importing from CSV?

[Geert Janssens]

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 viking2ev at san.rr.com:
> @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:geert.gnucash at kobaltwit.be]
> Sent: 11 May, 2022 02:27
> To: gnucash-user at lists.gnucash.org; gnucash-user at gnucash.org
> Cc: viking2ev at san.rr.com
> 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 viking2ev at san.rr.com:
> > 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
> > 
> > gnucash-user at gnucash.org
> > 
> > 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. -----