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
Post a Comment