General information
Title:
How can I check if numeric field is 0 or blank
old record example
Sample# 1234567
test1result 2.45
test2result
test3result 1.12
..test55result 4.24
I only want to copy where there is a value, either zero or a number.
I can't find a way to exclude test2 since it is blank. (There 55 result fields but usually only 5 - 10 have a value).
new record layout
Sample# Test# Result
Something like
Select 1
IF !(ALLTRIM(STR(test1result)) = " ") then
value = test1result
select 2
append blank
replace sample# with samplevaraible
replace test# with 5
replace result with value
ENDIF
Thanks for any help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only