file formatting w/"horrible" files.

glen.gold_at_esb.ie
Date: 01/26/04 

Date: 26 Jan 2004 08:55:48 -0800

hi all,
easy question but havent an answer.
apologies in advance for dumping horrible logs at you ... rather now
than in the future though.

i have a file about 350k ... cant awk it properly to get about 10 +
fields out.
the format is changeable:

ie: one part of the file looks like this:
<snip>
13524,0,3,6,SAPSND-Weekly,SAPSND-Weekly,HO204S,HO204S,1074934622,0000000008,1074
934630,HO204S-dlt3rob0,1,,,,,,1511626,root,1,17,0,0,,HO205S,1,34,0,,,1,/oracle/S
ND/920_64/dbs/sap_weekly_backup,1,1511626,HO204S-dlt3rob0,HO204S,1074934622,0000
000008,1074934630,6,the backup failed to back up the requested
files,3,01/24/04
08:57:06 - connecting,01/24/04 08:57:06 - connected; connect time:
000:00:00,01/
24/04 08:57:10 - end writing,0,0,0,,,,,,,,,,,,0
</snip>

another part like this:
<snip>
13512,0,3,0,HO207S,HO207S-Weekly,HO207S,HO207S,1074902822,0000003177,1074905999,
HO207S-dlt3rob0,2,,16163751,79424,,,1511650,root,1,0,0,0,,HO205S,1,34,0,,,1,ALL_
LOCAL_DRIVES,2,979026,HO207S-dlt3rob0,HO207S,1074903429,0000000008,1074903437,13
4,unable to process request because the server resources are
busy,5,01/24/04 00:
17:14 - connecting,01/24/04 00:17:15 - connecting,01/24/04 00:17:15 -
connected;
 connect time: 000:00:00,01/24/04 00:17:16 - mounting DFM406,01/24/04
00:17:17 -
 end writing,0,1,1511650,HO207S-dlt3rob0,HO207S,1074903499,0000002501,1074906000
,0,the requested operation was successfully completed,9,01/24/04
00:18:24 - conn
ecting,01/24/04 00:18:25 - connecting,01/24/04 00:18:25 - connected;
connect tim
e: 000:00:00,01/24/04 00:18:25 - mounting DFM406,01/24/04 00:19:28 -
mounted; mo
unt time: 000:01:03,01/24/04 00:19:34 - positioning to file 8,01/24/04
00:21:10
- positioned; position time: 000:01:36,01/24/04 00:21:10 - begin
writing,01/24/0
4 00:59:52 - end writing; write time:
000:38:42,16163751,79424,0,6977,,,,,,,,,,,
0

what is this:
veritas logs -- each field revealing wonderfull news of backups
<<barf>>

what i've done so far: used sed and tr to get rid of commas and got
some spaces going as i was planning on using awk to grab the fields
... i've realised things in the file are horrible to work with and am
stuck.

what i want:
to grab about 10 fields in this entire file but struggling to get to
them ...

error i encounter (after introducing commas and spaces):
<snip>
awk: cannot have more than 1024 fields
</snip>

Look forward to thoughts ;)

peace-
g.

Relevant Pages

  • Re: Can IT deal with change? was:
    ... a Formal Change Request had to be made, ... Mr Dashwood... ... providing a service to our Business?" ...
    (comp.lang.cobol)
  • Re: if-modified-since question (protocol problem?)
    ... request, but in response you are interested only if your request ... To base the decision on whether there is something 'new to show' would require knowledge about something 'old' - a cached resource. ... No Last-Modified header is sent in the response, ...
    (comp.infosystems.www.authoring.html)
  • Re: When to check the return value of malloc
    ... You complain that malloc causes problems. ... then check back later to see if memory is available. ... respond back that the request was not honoured. ...
    (comp.lang.c)
  • Re: [EGN] Re: [OT] Re: Hackers
    ... > It had that effect because I conformed to your request. ... > THIRTY YEARS of big talk by programmers, Colleen Rowley, and FBI agent ... Corey Murtagh ...
    (comp.programming)