How to remove currency symbol prepend?

R. Victor Klassen rvklassen at gmail.com
Tue Mar 24 07:00:06 EDT 2015


You are dealing with a bug that (I believe) is to be fixed in the next release.  Meantime, this is what I do on a Mac (yes, it’s ugly):

1) save as CSV - choose the right field separator so that if you have punctuation in your description fields it isn’t treated as a field separator;
2) open a terminal window, and cd to the directory containing the file you saved.
3) run sed -e 's/C\$//g' < file.csv > corrected.csv 
where file.csv is the file you saved, and corrected.csv has those annoying C$’s removed.  

Now you can open the resulting file in a spreadsheet and copy it into a word processing document table, as you please.  If you’re on windows, I don’t know the equivalent to steps 2 and 3.

On Mar 23, 2015, at 7:07 PM, bobolink <bobmoffatt at telus.net> wrote:

> I am the treasurer of not-for-profit organization in Canada and am using
> Gnucash to set up a basic bookkeeping system. I'm pleased with the results
> so far, however, I'm irritated by the fact that I can't remove the currency
> sign at the front of an amount in reports, for example. If I copy a Balance
> Sheet to Excel for presentation purposes, the symbols remain and are time
> consuming to remove. I've seen a couple of questionable solutions on the
> internet but they apply to Linux and not Mac or Windows. It seems to me that
> this shouldn't be complicated and easy to fix but I have no clue how to do
> it. Does anybody have a solution to this relatively minor, but irritating
> issue? Thank you!
> 
> 
> 
> --
> View this message in context: http://gnucash.1415818.n4.nabble.com/How-to-remove-currency-symbol-prepend-tp4677145.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list