Check Is Numeric

Check Is Numeric

  
Is there a function which can check if the text can be number?

For example:

In the database,

Field A
31224
Fruit
Apple
23541

I would like to show only data without number. So the output shoule be:
Field A
Fruit
Apple
Hi Richard,

You have function to validate the content like this:
TextToDecimalValidate() or TextToIntegerValidate()

And then the corresponding ones to convert them:
TextToDecimal() or TextToInteger()

then if iterate through the records you collected from the database, or any other source, you should be able to filter them.

Hope it helps!
Hermínio Mira
Or you do the filter directly on the query
Hi Richard,

For performance reasons, filter directly on the query.

Regards,
Rafael Pereira 
Hi,

I was just trying to be generic, hence the " from the database, or any other source ". :)