Skip to main content
  • EN

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

i.e. ISNUMBER() like in SQL

Thx Brian

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

^\d*$

The AttributeValidator transformer can test for numeric values.

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


Community Stats

30,194
Posts
114,615
Replies
37,857
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.