Shell Programming and Scripting

Hi
Can anyone please help me in resolving my issue.
I have a file with entries like this
t9787ms 99970 22/08/2010 12:30 /www.google.com
t9788ms 99942 22/08/2010 12:40 /www.google.com
t4788ms 88942 22/08/2010 01:40 /www.google.com

there are around 5 lakh records of this type my requirement is to change the file to
<tid>t9787ms</tid> <dlr>99970</dlr> <dat>22/08/2010</dat> <tim>12:30</tim> <url>/www.google.com</url>
all the entries needs to be changed in this way .

give a sample for you, you can finish the rest.

Code:

awk '{print "<tid>",$1,"</tid>", "<dlr>" $2 "</dlr>"  }' infile

yeah this would give the exact format you want:

Code:

awk '{print "<tid>"$1"</tid>", "<dir>"$2"</dir>", "<dat>"$3"</dat>", "<tim>"$4"</tim>", "<url>"$5"</url>"}' infile >infile.new; rm -rf infile; mv infile.new infile

Thanks alot that worked
is there any chance to add <XML> at the start of the file and </XML> at the end . I will be appending these kind of records to the same file daily .
example :
day 1: <XML>
<tid>s99152g</tid> <dir>33420</dir> <date>29/Aug/2010</date> <time>02:46:48</time> <url>/service/claimadmin/quicklop/dcx</url>
<tid>s07560k</tid> <dir>33132</dir> <date>29/Aug/2010</date> <time>03:31:55</time> <url>/service/claima
dmin/quicklop/dcx</url>
</XML>

day 2 :
<tid>s99152g</tid> <dir>33420</dir> <date>29/Aug/2010</date> <time>02:46:48</time> <url>/service/claimadmin/quicklop/dcx</url>
<tid>s07560k</tid> <dir>33132</dir> <date>29/Aug/2010</date> <time>03:31:55</time> <url>/service/claima
dmin/quicklop/dcx</url>
<tid>s07560k</tid> <dir>33132</dir> <date>29/Aug/2010</date> <time>03:44:47</time> <url>/service/claima
dmin/quicklop/dcx</url>
</XML>
new records needs to be added between these <XML> tags is it possible if so please let me know .

Thanks in advance

Code:

awk '
BEGIN{print "<XML>"} 
{print "<tid>",$1,"</tid>", "<dlr>" $2 "</dlr>"  }
END {print "</XML>"} 
' infile