I have a requirement to do some scripted text file processing on Windows. I plan on using a cross-platform tool (awk comes to mind) but as I don't have any real skills in anything (I used awk many years ago but not recently) I thought it best to come at it with a clean slate, as I will want to re-use the skills I pick up (almost entirely on Linux).
What I need to do in this case is read a CSV file, remove a few lines that are of no interest and combine a couple of fields to create new ones. Awk would definitely do this (albeit I have some reading to do to remember how) - but is it still the best tool for the job?
Mark