Parse CSV in bash and assign variables

Question

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.

Do you only want the first row that matches, or should all rows be returned? — Thor
– Thor, Commented Mar 12, 2013 at 1:50

Scrutinizer · Accepted Answer · 2013-03-12 07:18:02Z

19

Try a loop:

while IFS=, read dn mac partition
do 
  echo "Do something with $dn   $mac and $partition"
done < file

To select a record you could use a case statement:

P2=123
while IFS=, read dn mac partition
do 
  case $dn in
    ($P2) echo echo "Do something with $dn   $mac and $partition" ;;
    (*)   echo "Do nothing" ;;
  esac
done < file

edited Mar 12, 2013 at 7:18

answered Mar 11, 2013 at 23:01

Scrutinizer

9,9661 gold badge24 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kaptain K Over a year ago

using this I would be able to read the variables individually. I would be able to return them individually but I would want them to read by row. For example if I call row 2 using a variable P2 (say)It should be able to return MAC(2), DN(2) etc

Gilles Quénot · Accepted Answer · 2013-03-11 23:57:34Z

0

Using awk :

read -p "Gimme the DN integer >>> " i
awk -v i=$i -F' , ' '
    NR>1{
        dn[NR]=$1
        mac[NR]=$2
        partition[NR]=$3
    }
    END{
        for (a=2; a<=NR; a++)
            if (i == dn[a])
                print dn[a], mac[a], partition[a]
    }
' file.txt

edited Mar 11, 2013 at 23:57

answered Mar 11, 2013 at 23:15

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Comments

WYSIWYG · Accepted Answer · 2013-03-12 07:31:11Z

0

you can also try this

file1 stores all the DN for which you want to retrieve the information

#parse.awk

BEGIN { FS="," ; OFS= "\t"}

FNR==NR{ a[$1]; next }

$1 in a { print $1,$2,$3}

call awk -f parse.awk file1 csvfile.csv

answered Mar 12, 2013 at 7:31

WYSIWYG

4947 silver badges24 bronze badges

Collectives™ on Stack Overflow

Parse CSV in bash and assign variables

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related