Find all records with a number in it

[shady]

How can I find all records with a numeral or number in it. ie - 1car or car1 or ca2r

[Lee Smith]

One way would be to use the Filter Function in a new calculation field, and search on it.

SearchField (Calculation, Number Result) =

Filter (YourField; "0123456789")

Enter Find Mode

Type this in your new SearchField

>0

HTH

Lee

[Raybaudi]

Hi

another way is directly insert this chars in the field, while in Find Mode:

*#*

[shady]

I figured out one way that is long and tedious.

In find mode, I search for *"0", then new request for *"1", then new request for *"2", then ...... to *"9"

This finds all records with a number anywhere in the record. Beginning, middle, or end.

I wonder if there is an "or" function I can use instead of making 10 requests each time?

[Raybaudi]

But Shady

the way I said you is so simple...

doesn't it work for you ?

[shady]

Grazie così tanto. Funziona grande.

I just did it your way and yes, perfect!

I didn't know the # works for a number wildcard character.

Well actually, it didn't work. I did a find on the found set already.

I'll keep working on it, but I think this may be starting point.

Edited October 8, 2006 by Guest

[Raybaudi]

...another polyglottal here !

Which record it missed ?