AnsweredAssumed Answered

Finding records that only contain numbers, trouble with @ operator

Question asked by Vincent_L on Oct 22, 2018
Latest reply on Oct 22, 2018 by Johan Hedman

Hi,

 

I've a million of records, with a label field. Some of them, wrongly only contain numbers.

I want to find those and deletes them

 

I thought about finding all that start with a number, then constrained to those that ends with a number, with

==#* and ==*#, it works

But now I need to exclude from those, those that contain a letter

 

So I thought using a constrained omit like this ==*@* but that doesn't work

 

Is it possible via search only, why the @ doesn't work ?`

 

Thanks

Outcomes