| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv & " (re-post)
Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
csv & " (re-post)
The site is back up now.
Mike Kiekover wrote: Still having trouble with this. Links refered to in replies from the original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
csv & " (re-post)
that is soooo cool - the "Text files with no modification" macro work great.
One little quirk - It doesn't like the cells in the first column to be blank. I got rid of the blank column and it did exactly what I needed. With the blank column it only exported the first row. Mike "Dave Peterson" wrote in message ... The site is back up now. Mike Kiekover wrote: Still having trouble with this. Links refered to in replies from the original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson -- Posted via a free Usenet account from http://www.teranews.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
csv & " (re-post)
This line in JE's code:
For Each myRecord In Range("A1:A" & _ Range("A" & Rows.Count).End(xlUp).Row) is using column A to determine how many rows should be exported. Can you pick out a different column that always has data in it? If you can, you could modify that line of code: For Each myRecord In Range("A1:A" & _ Range("X" & Rows.Count).End(xlUp).Row) I used column X to find that last used row. Mike Kiekover wrote: that is soooo cool - the "Text files with no modification" macro work great. One little quirk - It doesn't like the cells in the first column to be blank. I got rid of the blank column and it did exactly what I needed. With the blank column it only exported the first row. Mike "Dave Peterson" wrote in message ... The site is back up now. Mike Kiekover wrote: Still having trouble with this. Links refered to in replies from the original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
csv & " (re-post)
Thanks for the info Dave - that could be useful if we want to limit the data
we export. Otherwise there isn't a reason we will not have data in all cells "Dave Peterson" wrote in message ... This line in JE's code: For Each myRecord In Range("A1:A" & _ Range("A" & Rows.Count).End(xlUp).Row) is using column A to determine how many rows should be exported. Can you pick out a different column that always has data in it? If you can, you could modify that line of code: For Each myRecord In Range("A1:A" & _ Range("X" & Rows.Count).End(xlUp).Row) I used column X to find that last used row. Mike Kiekover wrote: that is soooo cool - the "Text files with no modification" macro work great. One little quirk - It doesn't like the cells in the first column to be blank. I got rid of the blank column and it did exactly what I needed. With the blank column it only exported the first row. Mike "Dave Peterson" wrote in message ... The site is back up now. Mike Kiekover wrote: Still having trouble with this. Links refered to in replies from the original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson -- Posted via a free Usenet account from http://www.teranews.com -- Dave Peterson -- Posted via a free Usenet account from http://www.teranews.com |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
csv & " (re-post)
Quotes in csv files are very troublesome. I would go to the original text
and replace them with in. so 6" would be 6 in. "Mike Kiekover" wrote: Still having trouble with this. Links refered to in replies from the original post were not available, and I can't seem to reply to continue the original posting. I have text which includes " <inch marks. When I saveas csv, and open with notepad there are additional " added to the text. If I re-op in excell I do not see the additional ". For instance, a cell with < 6" shows in csv opened with notepad as < "6""" . same csv re-opened in excel still shows original format < 6" . Any way to NOT get additional quotes to show when opening in Notepad? -- Posted via a free Usenet account from http://www.teranews.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| "John Cleese" please re-post | Excel Discussion (Misc queries) | |||
| Related to "Counting cells..." (post below) | Excel Discussion (Misc queries) | |||
| Apology for the "ddd" post | Excel Discussion (Misc queries) | |||
| Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
Hybrid Mode
