Skip to main content
Question

Test for ISNUMBER() (Is Number)

  • February 7, 2018
  • 3 replies
  • 443 views

dbklingdom
Contributor
Forum|alt.badge.img+7

Is here a transformer or setup a Tester to test an attribute to be a number?

i.e. ISNUMBER() like in SQL

Thx Brian

3 replies

lottegis
Forum|alt.badge.img+1
  • February 7, 2018

I would use Regex in a Tester, with this expression:

^\d*$

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • February 7, 2018

The AttributeValidator transformer can test for numeric values.


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • February 7, 2018

Hey, Head slap Validator!! When I saw ^\\d*$ it reminded me of an Oracle operate I've use in the past which works as well ^-?[[:digit:],.]*$

Many Thanks All


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings