Help!

CSV file


Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map RSS
Next:  Pivot tables do not refresh in Office Mac version  
Author Message
Bob L.
External


Since: Nov 09, 2005
Posts: 1



PostPosted: Wed Nov 09, 2005 11:18 am    Post subject: CSV file
Archived from groups: microsoft>public>excel>datamap (more info?)

When I download a csv file into excel, manipulate it and then save it again
as a csv file, it saves it without the quotation marks ("") around the data.
I import it into another program (a different 3rd party) that needs the
quotations.

How do I save it in Excel so it doesn't get rid of the quotation marks?
Any help would be greatly appreciated.
Back to top
DanJustDan



Joined: May 19, 2006
Posts: 2



PostPosted: Fri May 19, 2006 1:31 am    Post subject: Re: CSV file [Login to view extended thread Info.]

There isn't a way to save it with the quotations. There is, however, an ugly method to put quotes back in.

Insert a column to the left of column A and between each column of your data. Fill-down the empty A column with "FIRSTQUOTE" (not in quotes) to the bottom of your data. Fill the columns between your data with "INNERQUOTE" (again without the quotes) and in the column to the right of your data fill with "ENDQUOTE".

Save your file as a CSV.

Open the file in Word (or any text editor) and do a find-replace "FIRSTQUOTE," (note the comma) with "

Find-replace ",INNERQUOTE," (note the leading and trailing comma) with "," (quote comma quote)

Finally replace ",ENDQUOTE" (note the leading quote) with "

Re-save the file. As long as the words FIRSTQUOTE, INNERQUOTE and ENDQUOTE didn't appear in your data to star with, you should have a quoted CSV file.

As I said, an ugly method but it works.
Back to top
mthompso



Joined: Dec 05, 2002
Posts: 557



PostPosted: Sun May 21, 2006 3:23 pm    Post subject: Re: CSV file [Login to view extended thread Info.]

Bob L. wrote:
When I download a csv file into excel, manipulate it and then save it again
as a csv file, it saves it without the quotation marks ("") around the data.
I import it into another program (a different 3rd party) that needs the
quotations.

How do I save it in Excel so it doesn't get rid of the quotation marks?
Any help would be greatly appreciated.


It sounds like you may be able to accomplish your task easier by using CSVed instead of Excel.

-Matt
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum