🚀 go-pugleaf

In <Bu282G.FF2@nntp-sc.Intel.COM> crichmon@sedona.intel.com (Chris Richmond) writes:


>Hi,

>	I just loaded up 123W and was wondering how to import ascii data
>into the spreadsheet.  I have an older SS, and I'm pretty sure I could do
>that there.  I have a data aquisition system that I want to plot the data for.
>Are there any FTP sites with FAQ lists, etc??

>Thanks, Chris
>-- 
> Chris Richmond         |     Internet: crichmon@sedona.intel.com
> Intel, Corp. C3-21     |     Phone: (602)-554-8827
> 5000 W. Chandler Blvd. |     This crazy is a world place. 
> Chandler, AZ  85226    |     My think losing I'm mind.
> 
Since excel and 123W are quite similar in many respects, I'll tell you
what I do in excel. You just open the ascii file in excel, just like
you would any other file. You select the entire first column, and 
then go to DATA and then PARSE, from the the menu. If the column
seprarators in your ascii file are not screwed up somehow, asking
excel to guess at the appropriate columns is good enough. If you
like what it guesses, you select ok and it'll format it into
the right number of columns for you. You then save the file as
a normal spreadsheet file.

This has worked for me always except in one instance where it
screwed up the column demarcations for some rows. If your ascii
file is not large, eyeballing and hand fixing should suffice in
such an instance.

Look up help for the parse command in 123W. (or similar expression).

Hope this helps.

Gyan P. Sinha
UBC, Vancouver.