Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NODATA

Status
Not open for further replies.

H1004

MIS
Oct 28, 2003
136
US
I have a question. If I want to put n/a for no data on a define numeric field.
How can I do that??
I try to do IF field1 EQ 9 THEN AMOUNT ELSE N/A.
But I can't do that coz it is numeric and n/a is string.
And I don't think I can use set nodata = n/a coz it is within a define field.
 
SET NODATA = 'N/A'
DEFINE FILE MYFILE
NEW_FIELD/I9 MISSING ON = IF FIELD_1 EQ 9 THEN AMOUNT ELSE MISSING;
END
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top