Formatting text from Excel

[shoplite]

We normally use Access but have been experimenting with Excel for database
upload for certain products/pages to shopsite.
Now if a field has a comma in it; for example a record within the Name field
may be:
Diamonds, 14k
Excel, upon exporting to tab delimited txt file, will enclose the field in
double quotes because of the comma delimiter in the field. Now if you bring
that tab file into shopsite, shopsite does not appear to strip out the
double quotes.
I guess the question is; from Excel what is the recommended export file
structure to prevent the above?
Thanks

[Katrina Morris]

Hi,

I use excel to upload my information. Here's the trick I found in the
Shopsite Knowledgebase:

1. Save the file in txt format.
2. Open the file in Word.
3. Find and replace all instances of double quotes ("") with **.
4. Find and replace all single quotes (") with nothing.
5. Find and replace all your previous double asterisks (**) with single
quotes (").
6. Save the file and proceed with the upload.

I do this every time before an upload. I wrote a macro for it, so all I do
is open up Word, hit my custom macro button, save and upload.

Hope this helps.

Katrina
"shoplite" <customerservice@shoplite.com> wrote in message
news:9nk7n0$cmr$1@support.shopsite.com...

We normally use Access but have been experimenting with Excel for database
upload for certain products/pages to shopsite.
Now if a field has a comma in it; for example a record within the Name
field
may be:
Diamonds, 14k
Excel, upon exporting to tab delimited txt file, will enclose the field
in
double quotes because of the comma delimiter in the field. Now if you
bring
that tab file into shopsite, shopsite does not appear to strip out the
double quotes.
I guess the question is; from Excel what is the recommended export file
structure to prevent the above?
Thanks