Shell Programming and Scripting

Hi everyone ,

i have one data file in which data appears like below


"a","b","c","d","e",
"1","","2","","3"
"3","","1","","5",
"5","","5","","8"
...


there are hundreds of record in that data file like this . now for corrosponding vale "e" there are three values 3,5,8 . Now i need to change all the value which corrosponds to variable e with some other number.
i think this can be done with the awk but i dont know how to do it

please help me regarding this .

Please provide expected output according to input which you posted.

How about this:

Code:

awk -F, -v new="55" ' { OFS="," ; if (NR == 1) { 
        for(i = 1; i<=NF && $i != "\"e\""; i++);
        print
    } else { $i="\""new"\"" ; print } }' test.dat

Output is:

Code:

"a","b","c","d","e",
"1","","2","","55"
"3","","1","","55", 
"5","","5","","55"

hi

i need to replace value corrospond to e with any number so that means we can put any number in place of 3,5,8

---------- Post updated at 01:24 AM ---------- Previous update was at 12:53 AM ----------

Hi chubler Xl

it is giving me error
awk syntax bailing error something like that

can u please why it is coming

---------- Post updated at 08:56 AM ---------- Previous update was at 01:24 AM ----------

hiii please help me regarding this

try "nawk" instead "awk"

If your still getting problems (after trying nawk) please post the exact error message and the output from

Code:

awk -W version

so we can determine whats going on.