Issue in reading data from CSV file in bash script

Question

I am writing a bash script which will read a CSV file and print the result in console with some string concatenation.

I am facing one issue with one string overwriting part of another when concatenating them in a bash script. Below is the whole code given and I am running it in Gitbash installed on my windows.

CSV File1 with two rows is given below

Apple,Cycle
Orange,Lamborgini

Script:

while IFS=, read -r x y
    do
            fruit=$x
            vehicle=$y
            echo "$y ran"
done < File1.csv

Actual Output:

ranle
ranborgini

Expected Output:

Cycle ran
Lamborgini ran

It works fine. There's no issue with that script and it gives the expected output. Maybe try to set -x and see what is happening for you? — darnir
– darnir, Commented Jan 22, 2020 at 10:38
Works on my machine. I think it's the csv file you are using (it looks like a '\r' issue). — majodi
– majodi, Commented Jan 22, 2020 at 10:46

Priya Jain · Accepted Answer · 2020-01-22 10:52:12Z

2

I found that the output contains carriage return that needs to be removed. For the example above this could be done using the tr tool:

 while IFS=, read -r x y                                                                                          
 do
            fruit=$x
            vehicle=$(echo "$y" | tr -d '\r')
            echo "$y ran"
done < File1.csv

And now it is giving the expected output.

answered Jan 22, 2020 at 10:52

Priya Jain

294 bronze badges

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

Comments

Oleg Russkin · Accepted Answer · 2020-01-22 11:01:28Z

1

On Windows file probably contains CLRF windows new lines with carriage return, not Unix ones.

Check this SO question and answers on options for converting new lines in file / line / string.

answered Jan 22, 2020 at 11:01

Oleg Russkin

4,4621 gold badge10 silver badges22 bronze badges

Collectives™ on Stack Overflow

Issue in reading data from CSV file in bash script

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related