All,
Can some tell me how can I split a file into columns which has multiple de-limiter.

i.e
I have a file looks like

Source of delivery: dbCristal
Report date of data: 01.04.2005
Date of interface creation: 21.04.2005:11.12.01
aa.txt: 14791;bb.txt: 11709;cc.txt: 10839;

My output need to be :

aa.txt,14791
bb.txt, 11709
cc.txt, 10839

Can this be accompolished using awk/shell script ?

Regs
Srn

Will something like this work

sed -e 's/:/,/g' | awk -F";" '{print $1,"\n",$2, ...}

Hi,
Thanks, However is there a way I can discard the all the lines above the required data i.e in this case required line is no 4, so i need to discard line 1,2,3.

1 Source of delivery: dbCristal
2 Report date of data: 01.04.2005
3 Date of interface creation: 21.04.2005:11.12.01
4 aa.txt: 14791;bb.txt: 11709;cc.txt: 10839;

many thanks

Just extend a bit.

cat file | grep ";" | sed -e 's/:/,/g' | awk -F";" '{print $1,"\n",$2, ...}

You can replace all the ";" with an carriage return. I've done it here by escaping the carriage return (with a "\").