Find and replace special character & with and using ssub

[karudonaldson]

Check Column D (four) for special characters:

1. Replace & with string AND
2. Remove characters ' ( ) /

$ cat example.csv

one,two,three,four,five
pan,pan,1,&,10
wye,wye,1,&,20
eks,wye,,1,'',10
zee,pan,1,(test),60

After transformation
$ cat example.csv

one,two,three,four,five
pan,pan,1,and,10
wye,wye,1,and,20
eks,wye,1,,10
zee,pan,1,,60

[aborruso]

@karudonaldson please also always write down what test you did, what didn't work for you. Don't just write what you want.

So it will be possible to give you a better answer. Thank you

[johnkerl]

@aborruso I think this question is well-posed

@karudonaldson how about:

cat 1546.csv

one,two,three,four,five
pan,pan,1,&,10
wye,wye,1,&,20
eks,wye,1,'',10
zee,pan,1,(test),60

cat 1546.mlr

for (k in ["four"]) {
    v = $[k];
    if (typeof(v) == "string") {
        v = ssub(v, "&", "AND");
        v = gsub(v, "['()/]", "");
    }
    $[k] = v;
}

mlr --csv --from 1546.csv put -f 1546.mlr

one,two,three,four,five
pan,pan,1,AND,10
wye,wye,1,AND,20
eks,wye,1,,10
zee,pan,1,test,60