I was using NUM() function in a transformer wherein i faced a peculiar issue.
Below is the definition of NUM function per IBM:
Num (expression)
expression is the expression to test. If expression is a number, a numeric string, or an empty string, a value of 1 is returned. If it is a null value, null is returned; otherwise 0 is returned.
Example: NUM(35E1)
After applying Num function it is should return 0, as field holds both numeric and alphanumeric characters. but it is returning 1
According to me due to the 'E' in the expresion, it is considering the number as an exponential form.
It would work as expected if i test it using NUM(35AE1), NUM(35C1) etc.
Any workaround anyone can suggest to overcome this ?