Hi Bruce,
awk is a quite powerful tool for that sort of thing.
Its basic structure is
/pattern/ {action}
i. e. it reads a line from the input file and if the line matches /pattern/ it
does {action} (e. g. write the line to output or write "," instead).
It is described very well in the manpage.
On Thu, Nov 13, 2003 at 04:03:58PM -0500, BruceG wrote:
> Hey all, not a Debian specific question. I am working with some CSV files.
> Daily extracts. I was able to combine them all with cat, then yank out the
> records I needed and popped then in a smaller file using grep. Finally
> yanked duplicates using sort < file | uniq -d
>
> Now comes the hard part. Each record begins with the date and hour. When I
> graph a month's worth of data, the graphs get nuts, so I want to remove
> specific entries from each line. Specifically, I want to replace the entry
> with a comma. A sample of the file is below:
> Date,TargetName ifIndex IfDescr,AvgIn,AvgOut,MaxIn,MaxOut
>
> 10/17/2003 0:00,10.2.1.101 127 10/100 utp ethernet (cat
> 3/5),0.12,0.04,0.18,0.05
>
HTH
--
Joachim Fahnenmüller
# Hi! I'm a .signature virus. Copy me into
# your ~/.signature to help me spread!
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
