Re: converting non comma separated ASCII data into MSWIN format

[Glen Wallace <gcwallace@xxxxxxx>]

I've had this problem, too.  I can get almost all the way there, but
I could never solve the problem with the "time" field, though.
Here's where I get to ...

1.    The text file can be converted to a standard Excel file using
       the "fixed width" data type.
2.    Use yy/mm/dd as the date format and the file should open
       showing your standard date format (mm/dd/yy, probably).
3.    Add column headings (DATE, TIME, OPEN, etc.).
4.    Save the file in, say, Excel 4.0 format.
5.    The file will now convert to MetaStock file format using
       DownLoader, but the time field is messed up.

Any ideas?



----- Original Message ----- 
From: "Denis Trover" <dtrover@xxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, March 19, 2002 4:38 PM
Subject: Re: converting non comma separated ASCII data into MSWIN format

> Ken,
> 
> Have you tried using the Text Import Wizard in Excel and setting the
> delimiters as space and/or tab?  I think that should work.
> 
> Denis
> 
>
> 
> "iamken@xxxxxxxxxxxxxxx" wrote:
> 
> > Hi,
> >
> > I have a boatload of non comma separated ASCII data that I need to
> > convert into Metastock format, but I don't know how to get commas
> > between the fields.  My feeble attempts to do this in Excel have failed,
> > but I think there must be a painless way to do this?  Any help would be
> > appreciated.
> >
> > Here's a sample of what I am working with.
> >
> > 19971201 925 118.71875 118.71875 118.71875 118.71875 2
> > 19971201 951 118.71875 118.71875 118.71875 118.71875 1
> > 19971201 954 118.78125 118.78125 118.78125 118.78125 1
> >
> > Thanks!
> > Ken