Shell Programming and Scripting

Hi experts,
please help for my script..I'm confused how to do this.

i have 3 .csv file(excel file)
The 5 .csv files are

A.csv,B.csv,C.csv

A.csv has

column1 column2
a 1
b 4
c 2
d 6
e 7
f 9

B.csv has

column1 column2
a 4
b 3
c 6
d 8
e 5
f 0

C.csv has

column1 column2
a 7
b 2
c 0
d 3
e 6
f 5


i like to have final report.csv that should have the format like

column1 column2 column3 column4
a 1 4 7
b 4 3 2
c 2 6 0
d 6 8 3
e 7 5 6
f 9 0 5

The final report.csv should just display the column2 values from each .csv files side by side.

Please help me how to do this in script..i am struggling how could i do this.Thanks in advance

Are they really all in the same order like that?

Code:

# open files for later
exec 5<b.csv
exec 6<c.csv
while read A B
do
        # read from b.csv
        read C D <&5
        # add more records to B
        B="$B $D"
        # read from c.csv
        read C D <&6
        B="$B $D"
        # print everything
        echo "$A $B"
done < a.csv > finalreport.csv
# close files
exec 5<&-
exec 6<&-

Hi corona
In .csv file the columns are comma seperated and so am getting different output rather than what i'm expected.
Can u help me in this

---------- Post updated at 08:43 AM ---------- Previous update was at 06:50 AM ----------

This code

Code:

# open files for later
exec 5<b.csv
exec 6<c.csv
while read A B
do
        # read from b.csv
        read C D <&5
        # add more records to B
        B="$B $D"
        # read from c.csv
        read C D <&6
        B="$B $D"
        # print everything
        echo "$A $B"
done < a.csv > finalreport.csv
# close files
exec 5<&-

works fine for space or tab seperated csv files..but my .csv files teh columns are "," (comma)
seperated.

so while reading from file it is reading the whole line(column1 and column2) as a
single column

my sample A.csv has

Code:

a,1

b,4

c,2

d,6

e,7

f,9

Is there any way identify the colums?

You could look at cut and paste

Code:

cut -d, -f2 b.csv> b.tmp
cut -d, -f2 c.csv> c.tmp
paste -d, a.csv b.tmp c.tmp > final.csv

Andrew

Never PM for tech support. It's against the rules and doesn't get me here any faster anyway. I'm not "on call".

Well of course my program's not going to work if your input's completely differently formatted than what you showed. Just a tiny change though.

Code:

# open files for later
exec 5<b.csv
exec 6<c.csv
IFS=","

while read A B
do
        # read from b.csv
        read C D <&5
        # add more records to B
        B="$B,$D"
        # read from c.csv
        read C D <&6
        B="$B,$D"
        # print everything
        echo "$A,$B"
done < a.csv > finalreport.csv
# close files
exec 5<&-
exec 6<&-

Thanks Corona688 and apmcd47.. Both worked...