I have some Excel files that contain some useful information (hard to believe I know!). I want to extract just that information.
Somewhere in the file it will say something like "Location: Blah" and I want to capture just "Blah".
I can use xls2csv to turn the XLS into text and then run that through (eg) awk. Because the XLS field in question will now be in quotes, the following gets me the whole "Location: Blah" value: xls2csv myfile.xls | grep -oE '"Location:([^"]+)"' What I want is something like this: myfile: Blah (the filename prefix is because I plan on processing about 100 files this way).
I'm sure this can all be done pretty simply within awk but the rate I'm going I'm going to end up with quite a complex script, so any guidance would be very welcome!