How to make awk ignore the field delimiter inside double quotes? [duplicate]

by

From the GNU awk manual (http://www.gnu.org/software/gawk/manual/gawk.html#Splitting-By-Content):

$ awk -vFPAT='([^,]*)|("[^"]+")' -vOFS=, '{print $1,$4}' file
"[email protected],www.example.com",field4
"[email protected]",field4

and see What’s the most robust way to efficiently parse CSV using awk? for more generally parsing CSVs that include newlines, etc. within fields.

More Related Contents:

  1. How do I use shell variables in an awk script?
  2. Bash tool to get nth line from a file
  3. How to strip out all of the links of an HTML file in Bash or grep or batch and store them in a text file
  4. Parse HTML using shell
  5. How to grep for case insensitive string in a file?
  6. Expansion of variables inside single quotes in a command in Bash
  7. Reading quoted/escaped arguments correctly from a string
  8. Can a shell script set environment variables of the calling shell? [duplicate]
  9. How can I do a recursive find/replace of a string with awk or sed?
  10. How to add a progress bar to a shell script?
  11. What is the purpose of “&&” in a shell command?
  12. How can I remove the extension of a filename in a shell script?
  13. How do I escape the wildcard/asterisk character in bash?
  14. awk in bash with ls and variable
  15. How can I count all the lines of code in a directory recursively?
  16. How does Ctrl-C terminate a child process?
  17. Copy folder recursively, excluding some folders
  18. Variable interpolation in the shell
  19. What does ” 2>&1 ” mean?
  20. How do I read user input into a variable in Bash?
  21. Count number of lines in a git repository
  22. How do I check if a directory exists or not in a Bash shell script?
  23. Insert multiple lines into a file after specified pattern using shell script
  24. shell script respond to keypress
  25. How do I get both STDOUT and STDERR to go to the terminal and a log file?
  26. -bash: __git_ps1: command not found
  27. How to append a string at end of a specific line in a file in bash [duplicate]
  28. What is the shortest way to get n-th column of an output?
  29. docker entrypoint running bash script gets “permission denied”
  30. What does `kill -0 $pid` in a shell script do?

Leave a Comment