I have a csv of the format (Working on Bash on linux)
DN , MAC , Partition ,
123 , abc , xyz
321 , asd , asd
I am able to parse it using awk by using
eval MAC=($(awk -F "," '{print $1}' random.csv))
This is done for each column in the CSV and therefore I can call DN[2]
, MAC[2]
etc individually which is manual and parses them individually.
But how can I parse the csv by row?
For example : If I call for DN
is 123
, the corresponding MAC
and Partition
should also be returned.
Using
awk
:you can also try this
file1 stores all the DN for which you want to retrieve the information
call
awk -f parse.awk file1 csvfile.csv
Try a loop:
To select a record you could use a case statement: