|
PureBytes Links
Trading Reference Links
|
Ken
I've just tested both methods I mentioned in my first reply. They both work.
If using Word to change spaces to commas the document needs to be saved as a
.txt file so Excel can read it. However it is also possible to import your
data "as is" into Excel 2000 and specify the use of "space" as a delimiter.
Then it's simply a matter of saving the file in .csv format (comma
seperated).
Roy
> 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
>
>
>
>
|