Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
I need to export a .CSV file from excel and one of the fields needs to be exactly: "w.c. i.e. double quote, w, period, c, period What do I need to put in the cell for it to come out the right way? Thanks in advance! Billy -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
William,
It is normal that where a double quote is required within double quotes that the character is repeated, this will happen to your data when you output to a ..csv file. Any cell that contains a comma will also be wrapped in (double) quotes. (the comma is a field seperator, any commas that are data need to be preserved). The program receiving the .csv file should recognise the data received and remove those double quotes that were 'wrapping', as would happen in Word, Access, Lotus Notes etc. Open the file in Notepad to view the characters as they were output. Hope this helps. -- "William DeLeo" wrote: I need to export a .CSV file from excel and one of the fields needs to be exactly: "w.c. i.e. double quote, w, period, c, period What do I need to put in the cell for it to come out the right way? Thanks in advance! Billy -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
Unfortunately that does not help. The program that is reading in these files is a VisualFoxPro database and it is not handling the "wrapping". I need to try to trick it ... I don't care how it appears in excel, but I need the end result in the .csv file to be: "w.c. Is there no way of achieveing that? I am running macros to write the .csv file ... can I fix it that way somehow??? Thanks for your attention and yout time. -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
Is there no one that can offer suggestions? Macro or formula? Thanks -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
Maybe you could build your own formula that concatenates the values in each cell
in the row: I put asdf (in A1) qwer (in B1) w.c (in C1) I put this in D1: =""""&A1&""","""&B1&""","""&C1 and it evaluated to: "asdf","qwer","w.c Then I could drag that formula down the column. Select the column, copy it, paste it into notepad and save it as my .csv file. If you want to build a macro, you could have complete control over each field. Some sample code to get you started: Earl Kiosterud's Text Write program: www.smokeylake.com/excel (or directly: http://www.smokeylake.com/excel/text_write_program.htm) Chip Pearson's: http://www.cpearson.com/excel/imptext.htm J.E. McGimpsey's: http://www.mcgimpsey.com/excel/textfiles.html If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm William DeLeo wrote: Is there no one that can offer suggestions? Macro or formula? Thanks -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
export .CSV with field containing double quotes?
Thank you Dave ... I will resort to the Macro and follow your links as a guide. I appreciate the reply. Take care, Billy -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=529335 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert spreadsheet to csv with double quotes | Excel Discussion (Misc queries) | |||
Escape character for double quotes | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Export (or save as) .csv with text delimiters | Excel Discussion (Misc queries) | |||
Can Excel be pre-formatted to apply "double quotes" to data enter. | Excel Worksheet Functions |