[GNC] Reformat Bank Description to Capitalise Every Word

Adrien Monteleone adrien.monteleone at lusfiber.net
Fri May 8 17:37:17 EDT 2020


If they are in CSV, you can do this in a spreadsheet app like LibreOffice Calc or Excel. They both have functions for adjusting case.

If they are in some other format, then yes, sed would probably be the easiest route. (I suppose you could use it on a CSV too)

As for editing the XML directly for existing transactions, that is generally not supported, but that would probably have the same solution.

Regards,
Adrien

> On May 8, 2020 w19d129, at 3:22 PM, flywire <flywire0 at gmail.com> wrote:
> 
> My bank statements use uppercase text which is harder to read than mixed
> case. Is it possible to reformat the bank description to capitalise every
> word? It could happen as part of the import process on any field selected
> but ideally it would be nice to run on existing transactions without
> generating a changed transaction.
> 
> Maybe a sed command on the xml file (?).



More information about the gnucash-user mailing list