I have a task (Derived Column Task) and I want to write something like this :
ÃÂ ÃÂ IsNumeric(aColumnOfString) == true ? "All numbers" : "there are some characters"
Here aColumnOfString can be something like "123a5" or 12345".ÃÂ I do not want to simply check if the left-most character is a number or not.ÃÂ I want to check the entire expression and return me a TRUE or false.
A TRUE is returned ifÃÂ the entireÃÂ expression contains ONLY numbers, and FALSE otherwise.
I read some posting using regular expression. But that is not a solution for this situation.
Anyone knows how to accomplish this, please help!ÃÂ
View Complete Post