We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
$ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" a,"Cellvibrio" Winogradsky 1929,c $ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" | csvtk pretty -l a Cellvibrio" Winogradsky 1929,c - ------------------------------- # `csvtk fix` did not fix this. $ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" | csvtk fix -l | csvtk pretty -l [INFO] the maximum number of columns in all 1 rows: 2 a Cellvibrio" Winogradsky 1929,c - -------------------------------
However, when the quotes are only in the middle of fields, theres' no problem.
$ echo -ne "a,Cellvibrio\" Winogradsky 1929,c\n" a,Cellvibrio" Winogradsky 1929,c $ echo -ne "a,Cellvibrio\" Winogradsky 1929,c\n" | csvtk pretty -l a Cellvibrio" Winogradsky 1929 c - ---------------------------- -
According to this answer, the CSV format is not valid ~
The text was updated successfully, but these errors were encountered:
new commmand: fix-quotes, del-qoutes. #260
2d61d31
a913fad
Added two commands:
fix-quotes
del-quotes
Try it:
$ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" a,"Cellvibrio" Winogradsky 1929,c $ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" | csvtk fix-quotes | csvtk cut -f 1- a,"""Cellvibrio"" Winogradsky 1929",c $ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" | csvtk fix-quotes | csvtk pretty a "Cellvibrio" Winogradsky 1929 c - ----------------------------- - $ echo -ne "a,\"Cellvibrio\" Winogradsky 1929,c\n" | csvtk fix-quotes | csvtk del-quotes a,"Cellvibrio" Winogradsky 1929,c
Sorry, something went wrong.
No branches or pull requests
However, when the quotes are only in the middle of fields, theres' no problem.
According to this answer, the CSV format is not valid ~
The text was updated successfully, but these errors were encountered: