Shell Programming and Scripting

Hi
I have a file called a.txt which contain a lot of data. each file used "," to identify. But the 1st, 2nd and 3rd field contain space, can I delete it and the 5th fileld is about mins, but the original format used ".", I would like to change to mm:ss (example 11.33 changed to 11:33, 0 changed to 00:00, 9.23 changed to 09:23). Can help?

11111 ,client ,customer , 2859, 11.33, 8, 21.57, 252.62
11112 ,client ,customer , 2860, 26.43, 8, 7.82, 91.62
11113 ,client ,customer , 2861, 48.27, 25, 64.55, 753.82
11113 ,client ,customer , 2862, 56.45, 18, 51.64, 603.06
11114 ,client ,customer , 2872, 8.87, 5, 8.89, 103.78
11115 ,client ,customer , 2875, .00, 1, .26, 3.00
11116 ,client ,customer , 2878, 36.22, 18, 54.94, 641.54
11117 ,client ,customer , 2881, 1.30, 2, 2.07, 24.22
11111 ,client ,customer , 2883, 12.05, 8, 16.39, 191.34
11111 ,client ,customer , 2879, .00, 0, .00, .00
11111 ,client ,customer , 2873, .00, 0, .00, .00
11111 ,client ,customer , 2871, .00, 0, .00, .00

Code:

sed 's/ ,/, /g;s/\./:/' file

Hi,
Use this code.....the output goes to file named "err"
I have put the input in a file named as "Input.txt"
cat Input.txt | awk -F, '{
for(i=1;i<=NF;i++)
{
if(i<=3)
{
sub(/ $/,"",$i);
printf("%s,",$i);
}
else if(i==5)
{
split($i,temp,".");
printf("%02d:%02d,",temp[1],temp[2]);
}
else
{
printf("%s,",$i);
}
}
printf("\n");
}' > err

Thanks
Raghu

nothing change..after run the statement..

Code:

>cat file
11111 ,client ,customer , 2859, 11.33, 8, 21.57, 252.62
11112 ,client ,customer , 2860, 26.43, 8, 7.82, 91.62
11113 ,client ,customer , 2861, 48.27, 25, 64.55, 753.82
11113 ,client ,customer , 2862, 56.45, 18, 51.64, 603.06
11114 ,client ,customer , 2872, 8.87, 5, 8.89, 103.78
11115 ,client ,customer , 2875, .00, 1, .26, 3.00
11116 ,client ,customer , 2878, 36.22, 18, 54.94, 641.54
11117 ,client ,customer , 2881, 1.30, 2, 2.07, 24.22
11111 ,client ,customer , 2883, 12.05, 8, 16.39, 191.34
11111 ,client ,customer , 2879, .00, 0, .00, .00
11111 ,client ,customer , 2873, .00, 0, .00, .00
11111 ,client ,customer , 2871, .00, 0, .00, .00

Code:

>sed 's/ ,/, /g;s/\./:/' file
11111, client, customer,  2859, 11:33, 8, 21.57, 252.62
11112, client, customer,  2860, 26:43, 8, 7.82, 91.62
11113, client, customer,  2861, 48:27, 25, 64.55, 753.82
11113, client, customer,  2862, 56:45, 18, 51.64, 603.06
11114, client, customer,  2872, 8:87, 5, 8.89, 103.78
11115, client, customer,  2875, :00, 1, .26, 3.00
11116, client, customer,  2878, 36:22, 18, 54.94, 641.54
11117, client, customer,  2881, 1:30, 2, 2.07, 24.22
11111, client, customer,  2883, 12:05, 8, 16.39, 191.34
11111, client, customer,  2879, :00, 0, .00, .00
11111, client, customer,  2873, :00, 0, .00, .00
11111, client, customer,  2871, :00, 0, .00, .00

If you are expecting a change in the original input file then,

Code:

sed 's/ ,/, /g;s/\./:/' file > tmpfile
mv tmpfile file

else use the -i option if available in the sed version that you are using.

Rest, it works fine for me

thx!, the time can chanted to mm:ss. But the space cannot delete in 1st,2nd and 3rd field (not just one space in each field - may be 1 to many)...why?

HI,
I have cobined what matrixmadhan has posted and my answer and that works fine for me.
Here is what i used
cat Input.txt | sed 's/ ,/, /g' | awk -F, '{
for(i=1;i<=NF;i++)
{
if(i==5)
{
split($i,temp,".");
printf("%02d:%02d,",temp[1],temp[2]);
}
else
{
printf("%s,",$i);
}
}
printf("\n");
}' > err

Thanks
Raghuram