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



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 ?`