Question

Test for ISNUMBER() (Is Number)

  • 7 February 2018
  • 3 replies
  • 61 views

Badge +1

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

Badge +1

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

^\d*$
Userlevel 2
Badge +12

The AttributeValidator transformer can test for numeric values.

Badge +1

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

Reply