Having trouble finding non-numeric

[Thanh]

Hello,

I am having trouble with trying to perform a find function to find all non-numeric in a text field. Example:

12aa78

65g

The number and letter can be anything.

Thanks in advance for your help.

[aaa]

Hi, Thanh! Create one calc field as:

Case(Length(TextToNum(Text)) <> Length( Text ) or IsEmpty(Text),0,1).

Look attachment.

NonNumeric.zip

[Thanh]

Thanks aaa. It works great!

[-Queue-]

I am not certain if this is an issue in version 6, but it is in 5.5. Using TextToNum with a text field containing a single character of 'y', 'n', 't', or 'f' (at least in the English version) will produce a false positive. In such cases, appending an "a" to the TextToNum parameter solves the problem. So

Length(TextToNum("a" & Text)) = Length(Text) and not IsEmpty(Text)

is a more reliable calculation.

Note that the false positive characters may vary, depending on language version.