RE: Comma delimiter for csv downloads?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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?

"Les M" wrote:

> 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 "Text (Tab Delimited)". 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.
>
> "Nick B" wrote:
>
> > 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->Folder Options, View tab and verify that
> > Hide extensions for known file types is NOT selected.)
> >
> > "Les M" wrote:
> >
> > > 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 "Data/Text to Columns/Delimited/comma" 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.
.

Relevant Pages

  • RE: File extensions spoofable in MSIE download dialog
    ... notepad.exe (as a file with the usual ".log" extension would be) ... In no instance was I able to "silently" download and execute an executable ... These are the two browsers I tested with: ...
    (Bugtraq)
  • File extensions spoofable in MSIE download dialog
    ... File extensions spoofable in MSIE download dialog ... file extensions in the download dialog to make an executable program file ... The flaw is in the way Internet Explorer processes certain kind of URLs ... extension without a sign of EXE, and issue no Security Warning dialog ...
    (Bugtraq)
  • Re: IE will not open or DL Office ".doc" files, but will ".rtf" fi
    ... > From what I can tell, the status bar displays only the "label" of the link ... But getting back to the task at hand, trying to download a file, ... Document (for extension .doc) has another Action in its list: ... you may be able to detect the MIME type they were downloaded ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: File extensions spoofable in MSIE download dialog
    ... File extensions spoofable in MSIE download dialog ... I don't have internet explorer to test but rfc 2616 describes some "security considerations". ... > extension without a sign of EXE, and issue no Security Warning dialog ...
    (Bugtraq)
  • Re: Ftp from within excel
    ... ie when the sql server generated a csv file, this process is completed, the ... > connection when that file is done and then to start download. ... > Dim strDirectoryList As String ...
    (microsoft.public.excel.programming)