Re: [GNC] Reformat Bank Description to Capitalise Every Word

2020-09-03 Thread flywire
gnu sed v4.7 on win10 sed -i.bak '/^/s/\w\+/\L\u^&/g; s/^&Amp;\^|Trn:Description/\L^&/g' filename Delete the ^ escape characters if not on windows. On Sat, May 9, 2020 at 6:22 AM flywire wrote: > My bank statements use uppercase text which is harder to read than mixed > case. Is it possible to

Re: [GNC] Reformat Bank Description to Capitalise Every Word

2020-05-08 Thread Adrien Monteleone
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 fo

[GNC] Reformat Bank Description to Capitalise Every Word

2020-05-08 Thread flywire
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 generatin