Search Results

Thanks vgersh99! And now I can see how you did it I can apply it elsewhere too.

And thanks for the caveat ctsgnb. My real filter file is far far bigger, but $2 is always unique.

Try this:-

sed -e "s/^/'/" -e "s/ /' '/g" -e 's/$/'"'"'/' input.csv > output.csv

It puts a ' at the start and end of each line, and replaces all the spaces with ' '.

Dear all,

I am using awk to filter some data like this:-

awk 'NR==FNR{a[$2];next}($1 in a)' FS=":" filter.dat data.dat >! out.dat where the filter and input data look like this:-
...