[FIXED] How to parse a CSV in a Bash script?

Issue

I am trying to parse a CSV containing potentially 100k+ lines. Here is the criteria I have:

1. The index of the identifier
2. The identifier value

I would like to retrieve all lines in the CSV that have the given value in the given index (delimited by commas).

Any ideas, taking in special consideration for performance?

Solution

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.

Answered By - unwind

Answer Checked By - David Goodson (PHPFixing Volunteer)