UNIX for Dummies Questions & Answers

I have a file which have 2 columns.

chris doc,male
test,female

So in order to store the content of the first column i am doing this :-

Code:

for line in $( cat $test.csv ); do
     FIRST_COLUMN_VAR=$( echo $line | cut -d"," -f1 )
     SECOND_COLUMN_VAR=$( echo $line | cut -d"," -f2 )
     echo $FIRST_COLUMN_VAR

I get the output :-

chirs
doc
test

Which is wrong. So then i tried to put quotes so then my script recognizes as "chris doc" one word rather than 2 word .

Code:

for line in "$( cat $test.csv ); do
     FIRST_COLUMN_VAR=$( echo $line | cut -d"," -f1 )
     SECOND_COLUMN_VAR=$( echo $line | cut -d"," -f2 )
     echo $FIRST_COLUMN_VAR

I get the output :-
chris doc

It does not read the second row at all. Any hints or suggestions?

where read line
do
first_column=`echo "$line"|awk -F"," '{print $1}'`
second_column=`echo "$line"|awk -F"," '{print $2}'`
echo "$first_column"
done < test.csv

Thanks Vidhya. So i need to use AWK in order to get the column which contains space. Got it. I tried IFS=',' and couple of other stuff but everytime i was running into this problem.

Another one :

Code:

sed 's/\(.*\),\(.*\)/\1/' filename

there is no restriction that you need to use awk.. as dennis said you can do it by simple sed..
or simply awk -F"," '{print $1}' filename

Issue resolved

whats your logic can you post it??