Shell Script read CSV file (Skip Header)

Question

I have below SH script which reads test.csv file but it is not printing command what I am expecting. Please help

read header
while IFS="," read -r user role
do
    echo "btp assign security_role-collection $role --to-user $user"
    
done
} < test.csv

test.csv file records as below

user,role
[email protected],testrole1
[email protected],testrole2

Results what I am getting is:

 --to-user [email protected] testrole1
 --to-user [email protected] testrole2
btp assign security_role-collection  --to-user

but I am expecting below results instead. What am I doing wrong ?

btp assign security_role-collection  testrole1 --to-user [email protected]
btp assign security_role-collection  testrole2 --to-user [email protected]

Removing line ending has removed last line of output but still it does not explain why $"btp assign security_role_collection and role value is not printed on screen and email is printed first. — Lord OfTheRing
– Lord OfTheRing, Commented Oct 7, 2021 at 16:55

glenn jackman · Accepted Answer · 2021-10-07 17:35:49Z

1

When you read this line [email protected],testrole1 and the line has \r\n line endings, the value of $role is testrole1\r

The string you create looks like

btp assign security_role-collection testrole1\r --to-user [email protected]
.............................................^^

And when you print it, the carriage return moves the cursor to column 1.

You want

{
read header
while IFS="," read -r user role
do
    echo "btp assign security_role-collection ${role%$'\r'} --to-user $user"
    # ........................................^^^^^^^^^^^^^
done
} < test.csv

or

{
read header
while IFS="," read -r user role
do
    echo "btp assign security_role-collection $role --to-user $user"
done
} < <(sed 's/\r$//' test.csv)
# ..^^^^^^^^^^^^^^^^^^^^^^^^^

answered Oct 7, 2021 at 17:35

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

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

2 Comments

Lord OfTheRing Over a year ago

Thank you very much. It is working.

Walter A Over a year ago

Or IFS=$',\r'

Collectives™ on Stack Overflow

Shell Script read CSV file (Skip Header)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related