Re: parsing output for Excel

On 2/13/2008 8:45 AM, dwcasey@[EMAIL PROTECTED]
 wrote:
> I run a script that does some checks on many, many servers.
> 
> If an error condition exists, I write out to a file ERR: with the
> issue that was found.  I'm wanting to be able to create some format
> from this that will go into a spreadsheet.  Really just looking for
> ideas on what would be a good way to parse it that would be acceptable
> for Excel.  Like maybe grab a unique servername and all it's issues?
> 
> This is a cat *.out of the servers.out file created by my script.
> 
> srv.srv01.out:ERR: dummy not found for LTAPEDEV in pri srv01
> srv.srv01.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
> TSM srv01
> srv.srv02.out:ERR: dummy not found for LTAPEDEV in pri srv02
> srv.srv02.out:ERR: directory /dummy not found on filesystem in pri
> srv02
> srv.srv02.out:ERR: directory /dummy not found on filesystem in bkp
> srv02
> srv.srv02.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
> TSM srv02
> srv.srv03.out:ERR: dummy not found for LTAPEDEV in pri srv03
> srv.srv03.out:ERR: directory /dummy not found on filesystem in pri
> srv03
> srv.srv03.out:ERR: directory /dummy not found on filesystem in bkp
> srv03
> srv.srv03.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
> TSM srv03

I'd just replace "ERR: " with the FILENAME followed by a tab:

awk 'sub(/ERR: /,FILENAME"\t")1' *.out > err.txt

then open err.txt with Excel as tab-separated text.

	Ed.