Dreamweaver - Download repeated region extension issue

Author

Download repeated region extension issue

Aleks

2005-03-28, 6:32 pm

Hi,

I am using the 'download repeated region' extension to download a recordset
to a comma delimited file (Excel), it all works fine, the only problem is
that one of the fields has the following data:

"Employer Name, Inc."

The data in the database has a 'comma', as a result it moves the data to the
next cell because it 'thinks' it is the next column, when it really is just
a comma in the data.
How can I avoid this error to happen ? How can I display the data in the
same cell even though it may have commas ?

Aleks

Murray *TMM*

2005-03-28, 6:35 pm

Use the entity for a comma in the database - , or ,

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Aleks" <arkark2004@hotmail.com> wrote in message
news:d29e8h$gki$1@forums.macromedia.com...
> Hi,
>
> I am using the 'download repeated region' extension to download a
> recordset to a comma delimited file (Excel), it all works fine, the only
> problem is that one of the fields has the following data:
>
> "Employer Name, Inc."
>
> The data in the database has a 'comma', as a result it moves the data to
> the next cell because it 'thinks' it is the next column, when it really is
> just a comma in the data.
> How can I avoid this error to happen ? How can I display the data in the
> same cell even though it may have commas ?
>
> Aleks
>

Alan

2005-03-28, 6:35 pm

a similar way would be to alter the part of the code that's building the CSV
file, and have it put in the double-quotes or whatever it is that excel is
happy with when the fields -do- contain commas. In that repeat region to csv
code is a part that builds each line from something like this fake code-
(cell1)+','+(cell2)

{off-hand way to find out the default delimiter excel uses with comma
contents- perhaps- Fire up excel. make a dummy sheet. Put
something,and,some,more stuff in a row of cells. Do a save as .csv file then
open in text editor to see what it's using as delimiter}

or, use any other unlikely character as the delimiter, and inform users of
this so they can go through the excel import wizard quickly.