Thread View: comp.apps.spreadsheets
5 messages
5 total messages
Started by Chris Richmond
Fri, 04 Sep 1992 15:23
import ascii
Author: Chris Richmond
Date: Fri, 04 Sep 1992 15:23
Date: Fri, 04 Sep 1992 15:23
15 lines
1015 bytes
1015 bytes
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.
Re: import ascii
Author: Gyan P. Sinha
Date: Fri, 04 Sep 1992 19:29
Date: Fri, 04 Sep 1992 19:29
38 lines
2031 bytes
2031 bytes
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.
Re: import ascii
Author: janet l mather
Date: Fri, 04 Sep 1992 21:10
Date: Fri, 04 Sep 1992 21:10
5 lines
880 bytes
880 bytes
In lotus you load the file with /fi then either n for numbers or t for text. If you have a string of numbers seperated by spaces in the input file and prehaps some quoted strings you're done. If you have to bring in text then you used the /dp menu do parse the string. It is pretty straight forward.
Re: import ascii
Author: Tom Ho
Date: Thu, 10 Sep 1992 23:19
Date: Thu, 10 Sep 1992 23:19
3 lines
813 bytes
813 bytes
Another comment for Excel ascii import: You can also "add-in" the macro file "flatfile" which resides in the Macro Library folder. This macro will give you the command "Smart Parse" under the Data command. This feature will give better feature for parsing the data.
--
Tom Ho tomho@microunity.com (408) 734-8100
Re: import ascii
Author: Jess M Holle
Date: Fri, 11 Sep 1992 00:35
Date: Fri, 11 Sep 1992 00:35
11 lines
964 bytes
964 bytes
One comment, MS Excel's reading of text files is VERY slow compared to other spreadsheets available. A friend and I just did a test of Wingz vs. Excel for text file importation. Wingz was MUCH faster. I don't know Excel very well, but I also believe that Wingz is somewhat more limited on text formats accepted (i.e. tab separated columns ONLY, no space or comma separation). I just thought that this might be of interest to some. Jess Holle
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads