Shell Programming and Scripting

Hi,

I need help to delete a few words in every line in my file.

This is how the file look like:

VDC DQ 14900098,,,,157426.06849776753,786693.2919373367
10273032,,,,157525.49445429695,776574.5546672409
VDC DG ,10273033,,3er55,,149565.57096061576,801778.9379555212
AS174 892562,,,,,

I want to remove anything in red...i,e keep everything after the 5th ',' (you need to count the ',' from the right/end of line).

Thanks in advance.

Code:

awk -F"," '{
        for(i=NF-4;i<=NF;i++)
        printf ","$i
        print ""}' a.txt

Thank you!!

It works perfectly.