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!.