Bash: Parse CSV with quotes, commas and newlines

by

As chepner said, you are encouraged to use a programming language which is able to parse csv.

Here comes an example in python:

import csv

with open('a.csv', 'rb') as csvfile:
    reader = csv.reader(csvfile, quotechar=""")
    for row in reader:
        print(row[-1]) # row[-1] gives the last column

More Related Contents:

  1. Parsing a CSV file using gawk
  2. Split CSV files into smaller files but keeping the headers?
  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. using bash (sed/awk) to extract rows AND columns in CSV files?
  5. How to delete rows from a csv file based on a list values from another file?
  6. Some troubles with using sed and awk [closed]
  7. How do I use shell variables in an awk script?
  8. How can I do a recursive find/replace of a string with awk or sed?
  9. Bash tool to get nth line from a file
  10. How can I remove the extension of a filename in a shell script?
  11. awk in bash with ls and variable
  12. How to make the ‘cut’ command treat same sequental delimiters as one?
  13. Remove first N lines of a file in place in unix command line
  14. How to add to the end of lines containing a pattern with sed or awk?
  15. Sort a text file by line length including spaces
  16. Parsing variables from config file in Bash
  17. How to make awk ignore the field delimiter inside double quotes? [duplicate]
  18. Specify other flags in awk script header
  19. Check if all of multiple strings or regexes exist in a file
  20. How to remove double-quotes in jq output for parsing json files in bash?
  21. How to find/replace and increment a matched number with sed/awk?
  22. Using cut command to remove multiple columns
  23. find difference between two text files with one item per line [duplicate]
  24. Grep output with multiple Colors?
  25. Using grep to search for hex strings in a file
  26. How to append a string at end of a specific line in a file in bash [duplicate]
  27. How to get the PID of a process in a pipeline
  28. What is the shortest way to get n-th column of an output?
  29. How to grep for case insensitive string in a file?
  30. How can I format the output of a bash command in neat columns

Leave a Comment