Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert excel (.xls) to tab delimited (.txt) without double quotat
When converting my excel spreadsheet to tab delimited, I get double quotation
marks around anything that has a comma. This is making the datafeed in my website appear unclean. Is there any way around this? -- Andrea |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert excel (.xls) to tab delimited (.txt) without double quotat
Yes, but it involves another step outside of Excel. When you select
tab-delimited, that is the behavior you get. As soon as you save your file, open it in NotePad or EditPad (an even more robust notepad program) and do a Search/Replace. Ctrl-H usually brings up the window. Search: "," Replace: , Replace All Then save the document again. Will this work for you? -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Andrea" wrote: When converting my excel spreadsheet to tab delimited, I get double quotation marks around anything that has a comma. This is making the datafeed in my website appear unclean. Is there any way around this? -- Andrea |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert excel (.xls) to tab delimited (.txt) without double qu
Slight correction... since the quotes are around an entire field, just search
for all quotations and replace them with nothing. Search: " Replace: (leave completely blank) BTW, make sure you don't import this new file into a program that interprets commas as delimiters, too. That's why Excel adds the Quotes. Pretty much any program worth its salt will see those quotes and know this field is a word with a comma in it and import it properly. You might not always need to correct this data, though you didn't indicate what you were doing with it, so... That should do it. -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "JBeaucaire" wrote: Yes, but it involves another step outside of Excel. When you select tab-delimited, that is the behavior you get. As soon as you save your file, open it in NotePad or EditPad (an even more robust notepad program) and do a Search/Replace. Ctrl-H usually brings up the window. Search: "," Replace: , Replace All Then save the document again. Will this work for you? -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Andrea" wrote: When converting my excel spreadsheet to tab delimited, I get double quotation marks around anything that has a comma. This is making the datafeed in my website appear unclean. Is there any way around this? -- Andrea |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert excel (.xls) to tab delimited (.txt) without double qu
Thanks! THAT was super easy! Worked great..!
-- Andrea "JBeaucaire" wrote: Slight correction... since the quotes are around an entire field, just search for all quotations and replace them with nothing. Search: " Replace: (leave completely blank) BTW, make sure you don't import this new file into a program that interprets commas as delimiters, too. That's why Excel adds the Quotes. Pretty much any program worth its salt will see those quotes and know this field is a word with a comma in it and import it properly. You might not always need to correct this data, though you didn't indicate what you were doing with it, so... That should do it. -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "JBeaucaire" wrote: Yes, but it involves another step outside of Excel. When you select tab-delimited, that is the behavior you get. As soon as you save your file, open it in NotePad or EditPad (an even more robust notepad program) and do a Search/Replace. Ctrl-H usually brings up the window. Search: "," Replace: , Replace All Then save the document again. Will this work for you? -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Andrea" wrote: When converting my excel spreadsheet to tab delimited, I get double quotation marks around anything that has a comma. This is making the datafeed in my website appear unclean. Is there any way around this? -- Andrea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab delimited text file import on double click | Excel Discussion (Misc queries) | |||
How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
How do I import/convert tab delimited text files into Excel? | Excel Worksheet Functions | |||
Exporting single or double quote delimited files | Excel Worksheet Functions | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) |