Manipulating a log with a Script

[Rogelio Quintanilla]

Hi folks!

I am having a problem with a shell script??? since I am new on Shell scripting but right now learning a lot with your help???

I have a log file with this format (MRTG log file format) ;)

1045784114 60 59 60 59
1045783813 63 62 63 62
1045783800 62 61 63 62

Basically, I want to replace the space ??? ??? character with a comma ???,??? character, so I can export this file to a Database and read the contents with this CSV format.

Also, need to add a value in the beginning of each line, so the new file can be read like this:

Hostname,1045784114,60,59,60,59
Hostname,1045783813,63,62,63,62
Hostname,1045783800,62,61,63,62

I tried more, and cat, but cant get this working???
Any help or hints will be really appreciated.

Rogelio

[A. Clay Stephenson]

tr ' ' ',' < infile > outfile

[S.K. Chan]

Something like this .. ?
$ cat file|sed 's/^/Hostname,/'|sed 's/ /,/g'

[Sridhar Bhaskarla · Accepted solution]

Hi Rogelio

sed -e 's/^/HOSTNAME,/g' -e 's/ /,/g' -e 's/,$//g' infile > outfile

-Sri

[Pete Randall]

and for the hostname:

sed 's/^/hostname/'

[James R. Ferguson]

Hi Rogelio:

Here's another way:

# awk -v hostname=$(hostname) 'BEGIN{ OFS=","};{$1=$1;print hostname,$0}' filename

In this case the actual server hostname is injected into the output lines.

Regards!

...JRF...

[Rogelio Quintanilla]

Thank you all for the answers!!!

Sridhar's command made the whole job in one step, thank you very much.

Best regards.

Rogelio