10 Jul
2017
10 Jul
'17
4:34 a.m.
At 11:57 2017-07-07, "Paul H. Tarver" paul@tpcqpc.com wrote:
I sometimes run into this with variables and/or fields. In either case, you can pre-test a value and/or format using the transform() function as well.
If TRANSFORM(a,"@L 999.99") = "***.**" Endif
The nice thing about this method is you can control exactly the format of the value you are testing.
Alternate test:
If occurs('*',TRANSFORM(a,"@L 999.99") ) > 0 Endif
Or the condition "*"$transform(...)
[snip]
Sincerely,
Gene Wirchenko