software

I have recently upgraded to Windows XP Home edition and have reinstalled all
my applications. I regularly download csv files from one particular site and
use them in Excel, but now they always download with all data in column A (in
the past they downloaded correctly as csv files, using separate columns).

In Control panel/Regional settings, comma is specified as the list
separator, but this is not having the required effect.

I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
time I download (and that process works), but I would like the default to
operate as it should.

Any helpful advice would be appreciated.

If you open one of the files in Notepad, before opening in Excel, can you
verify that the files have commas and not another delimiter?
Are the files being saved with the .csv extension, or by any chance are they
being saved with .csv.txt extension? (i.e. the actual extension is being
hidden -- open My Computer, Tools-gt;Folder Options, View tab and verify that
Hide extensions for known file types is NOT selected.)

quot;Les Mquot; wrote:

gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; my applications. I regularly download csv files from one particular site and
gt; use them in Excel, but now they always download with all data in column A (in
gt; the past they downloaded correctly as csv files, using separate columns).
gt;
gt; In Control panel/Regional settings, comma is specified as the list
gt; separator, but this is not having the required effect.
gt;
gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; time I download (and that process works), but I would like the default to
gt; operate as it should.
gt;
gt; Any helpful advice would be appreciated.

Nick,

The files have commas, and when Excel is using comma as delimiter all is
well. But I have to go through the process of Data/Text to
Columns/Delimited/comma to get Excel to recognise the commas as delimiters -
even though comma is specified in Regional settings as the list separator.

I normally download and open the files without saving them, so at the time
of opening, there isn't a file extension. However, if I download and try to
save, they try to save as quot;Text (Tab Delimited)quot;. If I override that and
force them to save as .csv, then they will open correctly in future.

What I have always done is simply download and open, use the info (stock
prices) and then exit without saving the file at all. And that's what I'd
like to continue to do. But since moving to Windows XP and reinstalling
Office, it seems that Excel just won't work that way.

quot;Nick Bquot; wrote:

gt; If you open one of the files in Notepad, before opening in Excel, can you
gt; verify that the files have commas and not another delimiter?
gt; Are the files being saved with the .csv extension, or by any chance are they
gt; being saved with .csv.txt extension? (i.e. the actual extension is being
gt; hidden -- open My Computer, Tools-gt;Folder Options, View tab and verify that
gt; Hide extensions for known file types is NOT selected.)
gt;
gt; quot;Les Mquot; wrote:
gt;
gt; gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; gt; my applications. I regularly download csv files from one particular site and
gt; gt; use them in Excel, but now they always download with all data in column A (in
gt; gt; the past they downloaded correctly as csv files, using separate columns).
gt; gt;
gt; gt; In Control panel/Regional settings, comma is specified as the list
gt; gt; separator, but this is not having the required effect.
gt; gt;
gt; gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; gt; time I download (and that process works), but I would like the default to
gt; gt; operate as it should.
gt; gt;
gt; gt; Any helpful advice would be appreciated.

Interesting. Sounds like, perhaps, a change on the server. Can you provide us
with a link to a sample file? If the file does not have an extension, then it
should be prompting you asking what program to open the file with. If it has
a CSV, then all should be well. Sounds like the files on the server have a
..txt extension instead perhaps. Any chance you can supply us with a link?

quot;Les Mquot; wrote:

gt; Nick,
gt;
gt; The files have commas, and when Excel is using comma as delimiter all is
gt; well. But I have to go through the process of Data/Text to
gt; Columns/Delimited/comma to get Excel to recognise the commas as delimiters -
gt; even though comma is specified in Regional settings as the list separator.
gt;
gt; I normally download and open the files without saving them, so at the time
gt; of opening, there isn't a file extension. However, if I download and try to
gt; save, they try to save as quot;Text (Tab Delimited)quot;. If I override that and
gt; force them to save as .csv, then they will open correctly in future.
gt;
gt; What I have always done is simply download and open, use the info (stock
gt; prices) and then exit without saving the file at all. And that's what I'd
gt; like to continue to do. But since moving to Windows XP and reinstalling
gt; Office, it seems that Excel just won't work that way.
gt;
gt; quot;Nick Bquot; wrote:
gt;
gt; gt; If you open one of the files in Notepad, before opening in Excel, can you
gt; gt; verify that the files have commas and not another delimiter?
gt; gt; Are the files being saved with the .csv extension, or by any chance are they
gt; gt; being saved with .csv.txt extension? (i.e. the actual extension is being
gt; gt; hidden -- open My Computer, Tools-gt;Folder Options, View tab and verify that
gt; gt; Hide extensions for known file types is NOT selected.)
gt; gt;
gt; gt; quot;Les Mquot; wrote:
gt; gt;
gt; gt; gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; gt; gt; my applications. I regularly download csv files from one particular site and
gt; gt; gt; use them in Excel, but now they always download with all data in column A (in
gt; gt; gt; the past they downloaded correctly as csv files, using separate columns).
gt; gt; gt;
gt; gt; gt; In Control panel/Regional settings, comma is specified as the list
gt; gt; gt; separator, but this is not having the required effect.
gt; gt; gt;
gt; gt; gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; gt; gt; time I download (and that process works), but I would like the default to
gt; gt; gt; operate as it should.
gt; gt; gt;
gt; gt; gt; Any helpful advice would be appreciated.

Nick,

Thanks for your attention. I'm sorry but I expect the following will not be
much help.

The site is a major stockbroker in Australia, and one needs to be a
registered user to logon and download watchlist information, but I really
doubt that there has been a change on the server at the same time I upgraded
and reinstalled everything.

When downloading these files, the downloaded file normally opens in Excel
within an IE6 window and displays no filetype, etc in the heading. The first
indication I can get of filetype is if I try to save it and, as mentioned
earlier, it tries to save it as Text (Tab Delimited).

However, I have just tried the download with a quot;Save Asquot; option, and before
I specify a file type, it has selected quot;csvquot;. In fact, if I proceed with that
and save as csv, and then open the saved file, Excel works just fine!

So I obviously have another quot;workaroundquot;, but not the real thing (I just
want to view the file without saving it).

Thanks again for your interest.quot;Nick Bquot; wrote:

gt; Interesting. Sounds like, perhaps, a change on the server. Can you provide us
gt; with a link to a sample file? If the file does not have an extension, then it
gt; should be prompting you asking what program to open the file with. If it has
gt; a CSV, then all should be well. Sounds like the files on the server have a
gt; .txt extension instead perhaps. Any chance you can supply us with a link?
gt;
gt; quot;Les Mquot; wrote:
gt;
gt; gt; Nick,
gt; gt;
gt; gt; The files have commas, and when Excel is using comma as delimiter all is
gt; gt; well. But I have to go through the process of Data/Text to
gt; gt; Columns/Delimited/comma to get Excel to recognise the commas as delimiters -
gt; gt; even though comma is specified in Regional settings as the list separator.
gt; gt;
gt; gt; I normally download and open the files without saving them, so at the time
gt; gt; of opening, there isn't a file extension. However, if I download and try to
gt; gt; save, they try to save as quot;Text (Tab Delimited)quot;. If I override that and
gt; gt; force them to save as .csv, then they will open correctly in future.
gt; gt;
gt; gt; What I have always done is simply download and open, use the info (stock
gt; gt; prices) and then exit without saving the file at all. And that's what I'd
gt; gt; like to continue to do. But since moving to Windows XP and reinstalling
gt; gt; Office, it seems that Excel just won't work that way.
gt; gt;
gt; gt; quot;Nick Bquot; wrote:
gt; gt;
gt; gt; gt; If you open one of the files in Notepad, before opening in Excel, can you
gt; gt; gt; verify that the files have commas and not another delimiter?
gt; gt; gt; Are the files being saved with the .csv extension, or by any chance are they
gt; gt; gt; being saved with .csv.txt extension? (i.e. the actual extension is being
gt; gt; gt; hidden -- open My Computer, Tools-gt;Folder Options, View tab and verify that
gt; gt; gt; Hide extensions for known file types is NOT selected.)
gt; gt; gt;
gt; gt; gt; quot;Les Mquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; gt; gt; gt; my applications. I regularly download csv files from one particular site and
gt; gt; gt; gt; use them in Excel, but now they always download with all data in column A (in
gt; gt; gt; gt; the past they downloaded correctly as csv files, using separate columns).
gt; gt; gt; gt;
gt; gt; gt; gt; In Control panel/Regional settings, comma is specified as the list
gt; gt; gt; gt; separator, but this is not having the required effect.
gt; gt; gt; gt;
gt; gt; gt; gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; gt; gt; gt; time I download (and that process works), but I would like the default to
gt; gt; gt; gt; operate as it should.
gt; gt; gt; gt;
gt; gt; gt; gt; Any helpful advice would be appreciated.

Just some comments/questions...

First, I'd double check the regional settings list separator character--no extra
trailing space characters/junk(?).

Second, if you save the file to a .csv file on your harddrive and then
doubleclick on that filename in windows explorer, does excel open it correctly
(separate columns for each field)?

Third (just a guess), I think I'd try to reregister excel so that it knows that
it owns the .csv extension.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver amp; /regserver stuff resets the windows registry to excel's
factory defaults.

Then test it out.

Good luck,Les M wrote:
gt;
gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; my applications. I regularly download csv files from one particular site and
gt; use them in Excel, but now they always download with all data in column A (in
gt; the past they downloaded correctly as csv files, using separate columns).
gt;
gt; In Control panel/Regional settings, comma is specified as the list
gt; separator, but this is not having the required effect.
gt;
gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; time I download (and that process works), but I would like the default to
gt; operate as it should.
gt;
gt; Any helpful advice would be appreciated.

--

Dave Peterson

Dave,

Firstly, thanks for your interest. I think I've made some progress, but I'm
not sure where to go next. Following are answers to your questions, plus new
information that, I think, makes the real problem much clearer.

1. Comma is definitely the list separator (no spaces, etc). Also the
/unregserver and /regserver things didn't make any difference.

2. When I'm using IE6 and download using the quot;Open in a New Windowquot; option,
all the data arrives in column A. When I try to quot;Save Asquot; it wants to use
quot;Text (Tab Delimited)quot;. When I change that to quot;CSVquot; and save, then reopen it,
I have the same problem. Reason for this is now obvious because I have opened
the file with Notepad and following are the first couple of rows....
quot;Name,Stock,Bid $,Offer $,Last $,Change,%,Open $,High $,Low $,Volumequot;
quot;M-W Fund - M-W
Fund,ABS,7.420,7.430,7.420,-0.140,-1.85,7.510,7.520,7.410,221210quot;

It's obvious, even to me, that the quotes are the problem. But that's not
the whole story...

3. When I'm using IE6 and I download using the quot;Save Asquot; option, it saves a
csv file. Opening it in Windows Explorer opens in Excel, with everythinhg in
the correct columns. Following are the first two rows of the file saved that
way. There are no quotes.
Name,Stock,Bid $,Offer $,Last $,Change,%,Open $,High $,Low $,Volume
M-W Fund - M-W Fund,ABS,7.660,7.450,7.560,0.000,0.00,0.000,0.000, 0.000,0

At this point I'm suspecting the download site, but then....

4. Perhaps I shouldn't mention this in this particular site, but I then
repeated 2. above using the Netscape browser. I downloaded using the quot;Open in
New Windowquot; option, and used quot;Save Asquot;. It saved as a csv file (never
mentioned anything else), and when displayed using Notepad, there were no
quotes.

This implies to me that the quotes aren't there when downloaded. but are
being added as part of the IE6/Excel process, but not as part of the
IE6/Netyscape process.

Does any of this make any sense?

quot;Dave Petersonquot; wrote:

gt; Just some comments/questions...
gt;
gt; First, I'd double check the regional settings list separator character--no extra
gt; trailing space characters/junk(?).
gt;
gt; Second, if you save the file to a .csv file on your harddrive and then
gt; doubleclick on that filename in windows explorer, does excel open it correctly
gt; (separate columns for each field)?
gt;
gt; Third (just a guess), I think I'd try to reregister excel so that it knows that
gt; it owns the .csv extension.
gt;
gt; Close Excel and
gt; Windows Start Button|Run
gt; excel /unregserver
gt; then
gt; Windows Start Button|Run
gt; excel /regserver
gt;
gt; The /unregserver amp; /regserver stuff resets the windows registry to excel's
gt; factory defaults.
gt;
gt; Then test it out.
gt;
gt; Good luck,
gt;
gt;
gt; Les M wrote:
gt; gt;
gt; gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; gt; my applications. I regularly download csv files from one particular site and
gt; gt; use them in Excel, but now they always download with all data in column A (in
gt; gt; the past they downloaded correctly as csv files, using separate columns).
gt; gt;
gt; gt; In Control panel/Regional settings, comma is specified as the list
gt; gt; separator, but this is not having the required effect.
gt; gt;
gt; gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; gt; time I download (and that process works), but I would like the default to
gt; gt; operate as it should.
gt; gt;
gt; gt; Any helpful advice would be appreciated.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Your message makes complete sense to me--but it's nothing that I know enough to
help.

I think I'd post in one of the internet explorer newsgroups and see if anyone
has a thought...

Or it could be the web page that looks at what browser you're using and does
things differently--again, that's over my head.

Les M wrote:
gt;
gt; Dave,
gt;
gt; Firstly, thanks for your interest. I think I've made some progress, but I'm
gt; not sure where to go next. Following are answers to your questions, plus new
gt; information that, I think, makes the real problem much clearer.
gt;
gt; 1. Comma is definitely the list separator (no spaces, etc). Also the
gt; /unregserver and /regserver things didn't make any difference.
gt;
gt; 2. When I'm using IE6 and download using the quot;Open in a New Windowquot; option,
gt; all the data arrives in column A. When I try to quot;Save Asquot; it wants to use
gt; quot;Text (Tab Delimited)quot;. When I change that to quot;CSVquot; and save, then reopen it,
gt; I have the same problem. Reason for this is now obvious because I have opened
gt; the file with Notepad and following are the first couple of rows....
gt; quot;Name,Stock,Bid $,Offer $,Last $,Change,%,Open $,High $,Low $,Volumequot;
gt; quot;M-W Fund - M-W
gt; Fund,ABS,7.420,7.430,7.420,-0.140,-1.85,7.510,7.520,7.410,221210quot;
gt;
gt; It's obvious, even to me, that the quotes are the problem. But that's not
gt; the whole story...
gt;
gt; 3. When I'm using IE6 and I download using the quot;Save Asquot; option, it saves a
gt; csv file. Opening it in Windows Explorer opens in Excel, with everythinhg in
gt; the correct columns. Following are the first two rows of the file saved that
gt; way. There are no quotes.
gt; Name,Stock,Bid $,Offer $,Last $,Change,%,Open $,High $,Low $,Volume
gt; M-W Fund - M-W Fund,ABS,7.660,7.450,7.560,0.000,0.00,0.000,0.000, 0.000,0
gt;
gt; At this point I'm suspecting the download site, but then....
gt;
gt; 4. Perhaps I shouldn't mention this in this particular site, but I then
gt; repeated 2. above using the Netscape browser. I downloaded using the quot;Open in
gt; New Windowquot; option, and used quot;Save Asquot;. It saved as a csv file (never
gt; mentioned anything else), and when displayed using Notepad, there were no
gt; quotes.
gt;
gt; This implies to me that the quotes aren't there when downloaded. but are
gt; being added as part of the IE6/Excel process, but not as part of the
gt; IE6/Netyscape process.
gt;
gt; Does any of this make any sense?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Just some comments/questions...
gt; gt;
gt; gt; First, I'd double check the regional settings list separator character--no extra
gt; gt; trailing space characters/junk(?).
gt; gt;
gt; gt; Second, if you save the file to a .csv file on your harddrive and then
gt; gt; doubleclick on that filename in windows explorer, does excel open it correctly
gt; gt; (separate columns for each field)?
gt; gt;
gt; gt; Third (just a guess), I think I'd try to reregister excel so that it knows that
gt; gt; it owns the .csv extension.
gt; gt;
gt; gt; Close Excel and
gt; gt; Windows Start Button|Run
gt; gt; excel /unregserver
gt; gt; then
gt; gt; Windows Start Button|Run
gt; gt; excel /regserver
gt; gt;
gt; gt; The /unregserver amp; /regserver stuff resets the windows registry to excel's
gt; gt; factory defaults.
gt; gt;
gt; gt; Then test it out.
gt; gt;
gt; gt; Good luck,
gt; gt;
gt; gt;
gt; gt; Les M wrote:
gt; gt; gt;
gt; gt; gt; I have recently upgraded to Windows XP Home edition and have reinstalled all
gt; gt; gt; my applications. I regularly download csv files from one particular site and
gt; gt; gt; use them in Excel, but now they always download with all data in column A (in
gt; gt; gt; the past they downloaded correctly as csv files, using separate columns).
gt; gt; gt;
gt; gt; gt; In Control panel/Regional settings, comma is specified as the list
gt; gt; gt; separator, but this is not having the required effect.
gt; gt; gt;
gt; gt; gt; I can go through the quot;Data/Text to Columns/Delimited/commaquot; process each
gt; gt; gt; time I download (and that process works), but I would like the default to
gt; gt; gt; operate as it should.
gt; gt; gt;
gt; gt; gt; Any helpful advice would be appreciated.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson