How to parse a CSV file in Bash?

by

You need to use IFS instead of -d:

while IFS=, read -r col1 col2
do
    echo "I got:$col1|$col2"
done < myfile.csv

Note that for general purpose CSV parsing you should use a specialized tool which can handle quoted fields with internal commas, among other issues that Bash can’t handle by itself. Examples of such tools are cvstool and csvkit.

More Related Contents:

  1. sh: 1: Syntax error: "(" unexpected error
  2. How do I write a bash script to restart a process if it dies?
  3. How to compare two strings in dot separated version format in Bash?
  4. Use Expect in a Bash script to provide a password to an SSH command
  5. How to declare 2D array in bash
  6. What does $@ mean in a shell script?
  7. Better way to rename files based on multiple patterns
  8. Convert date formats in bash
  9. Syntax error in shell script with process substitution
  10. Pipe to/from the clipboard in a Bash script
  11. What is the best way to ensure only one instance of a Bash script is running? [duplicate]
  12. Have bash script answer interactive prompts [duplicate]
  13. How to kill all processes with a given partial name? [closed]
  14. How do you find the original user through multiple sudo and su commands?
  15. Shell/Bash shortcut for bulk renaming of files in a folder
  16. How can I remove the last character of a file in unix?
  17. How to check if a file is empty in Bash?
  18. How to preserve line breaks when storing command output to a variable?
  19. How to use sed to remove the last n lines of a file
  20. Should PATH contain directories or full paths to binaries?
  21. Execute a command without keeping it in history [closed]
  22. The Bash command :(){ :|:& };: will spawn processes to kernel death. Can you explain the syntax?
  23. How do I run multiple background commands in bash in a single line?
  24. Add a newline only if it doesn’t exist
  25. Simple Socket Server in Bash?
  26. How do I get the difference between two dates under bash [duplicate]
  27. SUID not working with shell script
  28. Counter increment in Bash loop not working
  29. Problem with Bash output redirection [duplicate]
  30. bash: set array env variable and de-referencing it from any shell script fails

Leave a Comment