reading from csv file in shell scripting

Question

I am running a script run.sh. The script is executed as follows. $./run.sh read.csv The contents of the script are as follows.

   tail -n +2 $1 | while IFS="," read -r A B C D E F;
    do
        python test.py ${A} ${B} ${C} ${D} ${E} ${F}
    done

My question is "If i need to pass in additional command line arguments along with read.csv from the terminal like this (for Ex: $./run.sh name sex DOB read.csv) how do i modify the code so that it works fine.

Because if i pass any other command line arguments along with the file name(read.csv) i am getting access errors to the file read.csv

Why not just use python to parse csv

anubhava
– anubhava

2016-10-11 17:44:49 +00:00
Commented Oct 11, 2016 at 17:44 — anubhava
– anubhava, Commented Oct 11, 2016 at 17:44

SMA · Accepted Answer · 2016-10-11 17:44:31Z

1

Positional parameters is what you are after. This is how you can do it:

tail -n +2 $4 | while IFS="," read -r A B C D E F;##note now you would pass $4 to tail command which is your file name
do
    python test.py ${A} ${B} ${C} ${D} ${E} ${F}
done

You could access those values like name in $1, sex in $2, DOB with $3 and read.csv in $4

answered Oct 11, 2016 at 17:44

SMA

37.2k8 gold badges53 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

reading from csv file in shell scripting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related