![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
mamajoanToday I wasted my valuable time ;) in teaching myself how to use regex in Google Spreadsheets. It turns out that this is pretty ridiculously easy if you know how to construct a regex, or, in my case, how to google for a cheat-sheet.
This is how I balance my checkbook: I log on to my bank's website and copy-paste my transactions into a Google Sheet, then sort the items into categories and total them up etc. and then enter the totals into my checkbook.
Yes, I know there are many software packages that would do this for me, but I'm old skool and like to do stuff manually, so sue me.
Anyway, I always run a find-and-replace to get rid of all the stuff in the transaction lists like "POS PURCHASE TERMINAL DEBIT CARD PURCHASE" and all that crap that my bank's site puts in. But then I always end up with an 8-digit transaction code at the beginning of each line item, and that's annoying. So a regex can easily be constructed to say, "find everything that's an 8-digit number followed by a space, and remove it."
This is the kind of thing I find myself doing in order to avoid doing other things, of course. ;)
Anyway, it's good to know that the techie part of my brain hasn't completely deteriorated. Sometimes I wonder.
This is how I balance my checkbook: I log on to my bank's website and copy-paste my transactions into a Google Sheet, then sort the items into categories and total them up etc. and then enter the totals into my checkbook.
Yes, I know there are many software packages that would do this for me, but I'm old skool and like to do stuff manually, so sue me.
Anyway, I always run a find-and-replace to get rid of all the stuff in the transaction lists like "POS PURCHASE TERMINAL DEBIT CARD PURCHASE" and all that crap that my bank's site puts in. But then I always end up with an 8-digit transaction code at the beginning of each line item, and that's annoying. So a regex can easily be constructed to say, "find everything that's an 8-digit number followed by a space, and remove it."
This is the kind of thing I find myself doing in order to avoid doing other things, of course. ;)
Anyway, it's good to know that the techie part of my brain hasn't completely deteriorated. Sometimes I wonder.
