I have a csv file with error in one field, the fields are separated by "," but the error is in decimal field, for example 34.25," i need replace by 34.25",".
Search ," and replace by "," is not option, others fields will modified.
Advertisement
Answer
Check that the character before ," is not a double quote, and if it’s not, add the double quote:
sed 's/([^"]),"/1","/'