csv & " (re-post)

[Mike Kiekover]

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?

 

[Dave Peterson]

The site is back up now.

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?

 

[Guest]

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]

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]

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]

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