finding non-digits

[winklestork]

I can find digits (#), and characters (@), but how do you find letters? ie [a-z][A-Z]

[aaa]

I didn't tried but i think must work a..z

[winklestork]

More specifically, how do you find letters in a numeric field. If there are no numbers, e.g. "None", the symbol "?" will find it. But if there is a digit, e.g. "5 more", then I can't find it.

a..z (or a...z) won't do it.

[LaRetta]

I believe you will need a calculation. But this is one of the reasons mixing can be a problem. Sometimes we have no choice (which appears like your situation). Try a calculation, number of:

Length ( numField) ≠ Length ( Filter ( numField ; "0123456789" ) )

Search for a 1 in this calc. Or this one:

Length ( Filter ( Upper ( numField ); "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) )

Search for > 0. Or this one:

not Length ( Filter ( Upper ( text ); "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) )

Search for 0.