Skip to Content (Press Enter)
UserImage.jpg
Richard Chang
28Views
4Comments
Check Is Numeric
Question
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
0
0
01 Dec 2010
Copy Link
2019-06-17 07-29-54
Hermínio Mira
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
1
0
01 Dec 2010
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Or you do the filter directly on the query
1
0
01 Dec 2010
Copy Link
2019-08-20 01-57-17
RafaOutSystems
 
MVP
Hi Richard,

For performance reasons, filter directly on the query.

Regards,
Rafael Pereira 
0
0
02 Dec 2010
Copy Link
2019-06-17 07-29-54
Hermínio Mira
Hi,

I was just trying to be generic, hence the " from the database, or any other source ". :)
0
0
02 Dec 2010
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.