Forms to csv file

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

OK - maybe I am missing the forest for the trees..........

I have a survey form with about 50 questions. The users
answer is translated into a 1-5 rating. That part was
easy.

But I have two free form areas where they can write text
(comments). All works well until they put a comma or
character into their text which screws up the import into
Excel. I have also tried capturing the data into SQL with
the same results when I export the data.

How do all of you handle free form data which may include
comma's?

Is there an easy way to handle this data so that I dont
have to manually clean up the txt file?

I am expecting about 700-1000 survey reults to be submitted

Thanks
 
You will need to store the data in a database, then write a custom ASP/VBscript to replace the
commas when exporting.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Yes it will muck up your records in a CSV file especially if you use the comma as
your separator character.
CSV = Comma Separated Values or is that Character Separated Values?
 
The first one is correct...
CSV = Comma Separated Values
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Back
Top