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!
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450
Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER