[Tutor] mergin two csv files based on a common join

[qsqgeekyogdty at tiscali.co.uk]

Hello again,
Thanks for the replies on my previous post, but I have a different 
problem now and don't see how to deal with it in a smooth way.

I have two csv files where:

1.csv

"1", "text", "aa"
"2", "text2", "something else"
"3", "text3", "something else"

2.csv

"text", "xx"
"text", "yy"
"text3", "zz"

now I would like to have an output like:

"1", "text", "aa"
"1", "text", "xx"
"2", "text2", "something else"
"3", "text3", "something else"
"3", "text3", "zz"

I basically need to merge the two csv files based on the column-2

Thanks



________________________________________________

Escape to the sun - http://www.tiscali.co.uk/travel/

________________________________________________