HELP: survey data collection & analysis woes :S
 

I need urgent help and am new to linux scripting tools. I've got 5 CSV surveys which is similar to:

http://www.surveymonkey.com/ExportEx...rtExamples.zip

I am using SurveyMonkey.com to do 5 surveys (which are all exactly the
same), however it's separated for 5 societies. Results can be
downloaded/exported as CSV files (as you can see in the ExportExamples.zip
file). So there are 5 of those ExportExamples.zip (above), one for each
society am surveying. How can I combine the 5 Condensed.csv files so it's
one big file?

I need the Condensed in one big file. Then I want to make a spreadsheet program, or any program, to randomly chose 2 winners/users from the combined-list. (It's for a draw of 2 winners). Is this possible in some program? How can I do this?

Many thanks
Kev

Looks very much like a job for Perl. Text handling is part of it's original design.
Mind you, you may be able to unzip and concatenate using shell cmds if the files are layed out exactly the same.

Thanks for your reply..

I got a problem.
if email1@address.com entered survey 1, 2, 3, 4, 5 (all 5 surveys), then when I combine the surveys, is there any way to extract the email address uniquely? eg. it will only take that email address as appearing once, instead 5 times?