A table contains a number field where in strict data type - Number validation is not enabled . So, it allows text data as well as number data.
In find mode, how to identify the records which has text data in the number field.
Do a Find for '?' (no quotation marks).
Do you want to keep the text data?
If not, you can get rid of it using Replace Field Contents with GetAsNumber ( FieldName ).
Find "?" will only detect invalid dates no?
Length ( your_field ) is not equal to Length ( GetAsNumber ( your_field ) ) when your_field contains non integers.
This can be used in a calculated field and find on that.
If your_field contains valid decimals you'll have to use another calc.
Yes, you can define a calc field and do the Find that way. Sounds like a lot of trouble, though, if all you want to do is get rid of the stray characters.
(BTW - You could just use GetAsNumber ( field ) <> field. Shouldn't need the Length.)
No arg here Mike.
I usually think calcs the long way...
It would be depend on FM version, some need GetAsNumber() to get number value.
GetAsText(field) <> GetAsNumber(field)
may be steady?
Retrieving data ...