How to parse a CSV in a Bash script? How to parse a CSV in a Bash script? bash bash

How to parse a CSV in a Bash script?


bash csv shell

As an alternative to cut- or awk-based one-liners, you could use the specialized csvtool aka ocaml-csv:

$ csvtool -t ',' col "$index" - < csvfile | grep "$value"

According to the docs, it handles escaping, quoting, etc.

bash csv shell

See this youtube video: BASH scripting lesson 10 working with CSV files

CSV file:

Bob Brown;Manager;16581;MainSally Seaforth;Director;4678;HOME

Bash script:

#!/bin/bashOLDIFS=$IFSIFS=";"while read user job uid location do    echo -e "$user \    ======================\n\    Role :\t $job\n\    ID :\t $uid\n\    SITE :\t $location\n" done < $1 IFS=$OLDIFS

Output:

Bob Brown     ======================    Role :   Manager    ID :     16581    SITE :   MainSally Seaforth     ======================    Role :   Director    ID :     4678    SITE :   HOME

bash csv shell

First prototype using plain old grep and cut:

grep "${VALUE}" inputfile.csv | cut -d, -f"${INDEX}"

If that's fast enough and gives the proper output, you're done.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last