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.
- 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.
- Import some sample data.
- Select Tools:Worksheet Script from the menu.
- 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.
- 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).]
comment sign
Posted - 01/18/1999 : 7:26:00 PM
