[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: converting non comma separated ASCII data into MSWIN format



PureBytes Links

Trading Reference Links

I can think of a long way -
Open the txt file into excel and make sure that you break it into columns by
selecting fixed width. Then save the file and use the pull down "Save as
Type" and select CSV - at least that will get the comma's in there. No
guarantee that it will be the Metastock format...

-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of
iamken@xxxxxxxxxxxxxxx
Sent: Tuesday, March 19, 2002 5:46 PM
To: metastock@xxxxxxxxxxxxx
Subject: converting non comma separated ASCII data into MSWIN format


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