Shell Programming and Scripting

Hi Experts,

I am new to shell scripting. Need some help in doing one task given by the customer.

The sample record in a file is as follows:

Code:

3538,,,,,,ID,ID1,,,,,,,,,,,

It needs to be the following:

Code:

3538,,353800,353800,,,ID,ID1,,,,,COLX,,,,,COLY,

And i want to modify this record in the following manner:

1. 3rd & 4th Column should be equals to 2 zeroes at the end of the first field.
2. COLX & COLY needs to added and this value is static.

Needs to implement this using sed/awk in the most efficient way.

Thanks.

Moderator's Comments:

Code tags for code, please.

Perhaps from this, you can fathom the other parts?

Code:

$ awk 'BEGIN {FS=OFS=","} {$3=$1 "00"; $4=...} 1' file
3538,,353800,,,,ID,ID1,,,,,,,,,,,

Yes, I will check that once i get the access to any machine. But how i will add the static values at field no. 25 & 28.

Thanks

In the same way:

Code:

$13="COLX"

(or whatever field number it is, if not 13)