The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 comment sign

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
axelm Posted - 01/18/1999 : 7:26:00 PM
I have lots of data with "#" as a comment sign at the first position, meaning data after this sign in this row is not to read.
example:
4 7
2 3
#3 7
5 4
Is there a posibility to customize the data input, the way it accepts a comment sign? It should skip the line (not as missing data!), but read the next one again.
1   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 01/21/1999 : 7:36:00 PM
Origin Professional users could write a custom script to handle any odd characters in any way they choose, but standard Origin users need to rely on post-processing to clean up their data after import. With a custom worksheet Template the process could be seemlessly automated so that you never see those missing values.



  1. Setup File:Import:ASCII Options to handle your ASCII data, and set the "When non-numeric is found in numeric fields:" to Read as missing data.
  2. Import some sample data.
  3. Select Tools:Worksheet Script from the menu.
  4. Copy the following to the large text box:

    get wcol(1) -e last;
    for(ii=last;ii>0;ii--) {
    if(wcol(1)[ii]==0/0) mark -d wcol(1) -b ii -e ii;
    }

    and Check the Import check box.
  5. Click the Do It button.

The script deletes those rows that have a missing value in the first column. If you now save the Worksheet as a Template you can use it to import this type of data and automatically delete the 'commented' rows.

[This message has been edited by Greg (edited 01-21-99).]

[This message has been edited by rtoomey (edited 08-10-99).]


The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000