Dear Ones,
kindly help me to create a data file from the report file as shown here under( i am new one to unix KNOW BASIC COMMANDS)

file:rama.prt

(ist record)(3 to 4 lines of text with different filed names)
Name :M.LALITHA DOB:12/11/45 DESG :JA(P)
STANO:300175 DOA:11/12/07 BASIC:3020.0

(2nd record)(same 3 to 4 lines of text with different DATA same filelds)
NAME :M. RAJA DOB:10/10/65 DESG:CLEANER
STANO:10045 DOA:10/10/07 BASIC:1000.0

I WANT OUTPUT LIKE THIS SO WE CAN USE THIS DATA FILE AT ANYWHERE AND ALSO IN FOX PRO

M.LALILTHA 12/11/45 JA(P) 300175 11/12/07 3020.0 (SO ON...)
M.RAJA 10/10/65 CLEANER 10045 10/10/07 1000.0 (SO ON..)
(THE OUTPUT MAY TAB SEPARATOR ARE DELIMITED WITH" ",OR COMMAS

ADVACE THANKS TO SENIORS AND REQUEST TO GIVE SOLUTION
URS FAITHFULLY
MURTHY

give the exact details, from which field onward the name starts and
dob starts and from which line onward?? So that you can use different
commnd. Will you give real data starting from which line after the heading and the real data start point ??

hello sir i have report file lilke this


some heading
1 Name:rama rao dob:20/11/07 doa:10/12/07
faname:raja rao basic:2000 .............
.................

2 Name:sita ........................................

like 4 to 5 lines of text for one record and then second recod continues.

we can grep every record name, dob, doa ....for one record

i want to create a data file like

name dob doa fname basic
rama rao 20/11/07 10/12/07 raja rao 2000
..............

kindly give me hlep

dear friend why I have asked to give excat numbers of line of heading , b'coz the grep comd will start from that line onward only for that reason I have asked to give two records with the heading and can give solution .
Any way you can use grep comd with ~ (tilde) and also sed commd
for conveting the report file to data file say your particular digit's starting position is uniq than you can use either of the grep/sed and make data file.