Hi,

I found a script that writes the data from a feedback form to a text database. The only problem I am having w/ it is when I am importing the information in Excel it is listed in rows and not columns.
this is how it prints it to the text file now.

This is how I want it to be in the text file so that when I import it in Excel it can be listed in columns.

this is the sub routine that prints the data to that text file. I hope someone w/ some perl experience can help me out on this one.


Thanks in advance

This should work, but I haven't tried it.

Instead of

print FORM "$name -- $answer\n";
}

try

print FORM "$answer\t";
}
print FORM "\n";

That will give you the unlabeled information on one line, with a tab between each element. It won't give you the column labels, though.

If you want the column labels, you'll have to go through the loop twice:


You will end up with an extra tab at the end of the line, but that shouldn't be a problem.


------------------
JPD

thanks it worked like a charm