unix - sed: remove digits after word -


i have simple sed question.

i have data this:

2600,sale,"approved 911973",244.72 2601,sale,"approved 04735c",490.51 2602,sale,"approved 581068",52.82 2603,sale,"approved 009275",88.10 

how make this:

2600,sale,approved,244.72 2601,sale,approved,490.51 2602,sale,approved,52.82 2603,sale,approved,88.10 

notice numbers after approved gone quotes. can remove quotes with:

sed 's/,$//gn' file 

but don't know how remove spaces , digits.

thanks!

sed "s/\"approved[^,]*/approved/g" 

it finds quoted "approved" followed non-comma character, until first comma encountered, , replaces approved (no quotes)

2600,sale,approved,244.72 2601,sale,approved,490.51 2602,sale,approved,52.82 2603,sale,approved,88.10 

Comments