Hello !

I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.

Here is a sample of the file:

Code:

steev	YES	RGBA8888	0.55	2	2	2	2048
vahine	YES	RGBA8888	0.55	2	2	2	2048
winnick	YES	RGBA8888	0.55	2	2	2	2048

(Copied and pasted from Excel for Mac, but there should be ";")

And here is the simplified code I am trying to make work:

Code:

export IFS=";"

    file="Test.csv"
    more $file | while read name
    do
        echo $name
    done

And... it won't work. Nothing comes out.
If I just do "more $file", then I have a beautiful output:

Code:

vahine;YES;RGBA8888;0.55;2;2;2;2048^Mwinnick;YES;RGBA8888;0.55;2;2;2;2048^Mvenus;YES;RGBA8888;0.55;1;2;1;2048^Mvesper;YES;RGBA8888;0.55;1;2;1;2048

(I could not reproduce it here, but the "^M" are written in white on a black background.)

I have tried using cat or echo instead of more, without success, I have even tried sed and awk with some of the many solutions given on the internet, but they did not work neither, and I would prefer not to use awk if possible, since I do not really understand it yet.

Another strange thing is that if I do:

Code:

    fileContent=$(more $file)
    echo $fileContent

Then I have as output only the last line of the file and not the others...

I am kind of stuck here, without any additionnal idea.
I don't even absolutely want to use csv files, it is just that this format is convenient if many people have to change the source file, so if you have in mind a format easier to read with bash, let me know.

I hope I've given all the needed information and that one of you will have an idea...