I'm at #csvconf in Portland, OR, and just saw a good talk about basic bash commands that you can use to clean up data sets, ideally line-based, well formatted data like CSVs or log files. I didn't know about the `cut` and `tr` commands!
$ echo "MyCity,MyState,IWant:TheThingAfterTheColon,MyCountry" | cut -d',' -f3 | cut -d':' -f2
--> TheThingAfterTheColon
Here's the full talk with all the example bash commands.
https://github.com/nickcanz/csvconf2019/blob/master/csvconf_2019.pdf