3 Dec
2014
3 Dec
'14
11:53 a.m.
On 03/12, Mark Rogers wrote:
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
Would summat like this do?
echo $(basename -s .xls $myfile): $(xls2csv $myfile | grep -oE '"Location:([^"]+)"' | cut -d ':' -f 2)
Steve