Shell Programming and Scripting

Hello Im new here.I need to replace strings and change it into csv format, or at least saves the file as csv if that would work . Heres an example of my scenario

1) I have a log file, named abc.log, and its like a txt based file anyway, and the content looks like this

my-test1/lab_mt01.tst,lab_mt01.tst,ge-3/3/1.140
my-test2/lab_mt02.tst,lab_mt02.tst,lo0.140

2) I need a method to read this file, line by line, ignoring the first statement until it reaches the first slash, then from there, replaces the commas with semicolons, so it'll look like this

from
my-test1/lab_mt01.tst,lab_mt01.tst,ge-3/3/1.140
my-test2/lab_mt02.tst,lab_mt02.tst,lo0.140

to
lab_mt01.tst;lab_mt01.tst;ge-3/3/1.140
lab_mt02.tst;lab_mt02.tst;lo0.140

and saves it in csv format.

That would help for now. I really appreaciate your help. Im very new in shell/perl so I would hope an answer which suits the really2 'dummies' :P.

Thank you!.

to simply recplace all ',' characters with ';', you can use sed:

Code:

sed 's/,/;/g' < inputfile.log > outputfile.csv

To throw away everything up to the first slash, you can use sed again:

Code:

sed 's/^[^\/]*\///'

So that gives:

Code:

sed 's/^[^\/]*\///' < inputfile.log | sed 's/,/;/g' > outputfile.csv

But don't forget that this isn't much of a csv anymore without any commas to seperate things...

Thanks I'll update