[GNC] Removing "," (comma) delimiters from large numbers

2021-07-23 Thread flywire
You could have also picked a different field separator eg Semicolon (;) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are us

Re: [GNC] Removing "," (comma) delimiters from large numbers

2021-07-23 Thread Tim Hume via gnucash-user
I've solved my own question. In gawk at least, one can delineate fields by what they contain as opposed to what they are separated by. So what one does is set the FPAT variable as this: FPAT = "([^,]*)|(\"[^\"]*\")"; Then awk will recognise a field which looks like this "20,000" as a single fi

[GNC] Removing "," (comma) delimiters from large numbers

2021-07-23 Thread Tim Hume via gnucash-user
Hi, I'm exporting my transactions as CSV for processing by another program (awk - but that's not really relevant). Large numbers in the exported CSV have commas in them, like this: "20,000" In theory the quotes protect the comma from being considered a separator. But in practice it's hard to