[GNC] Setting Currency Format when importing from CSV?

[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. -----

> Please remember to CC this list on all your replies.

> You can do this by using Reply-To-List or Reply-All.