Function to check if input is non-numeric or numeric

Question

Is there any function to check whether the entered input is non-numeric or numeric? Thanks!... 
 OriginalPostID-106178 
 OriginalPostID-106178

Abhay Dalsaniya · Answer

janakik 
 Following code will tell whether it's a Numeric , Alfa Numeri c or Text . To test change the local!input to 1. 123, 2. "123abc", 3. "abc". 
 a!localVariables(
 local!input,
 {
 if(
 a!isNullOrEmpty(local!input),
 "It's Empty !",
 if(
 a!isNullOrEmpty(tointeger(text(local!input, "#"))),
 "It's a Text !",
 if(
 tointeger(text(local!input, "#")) = local!input,
 "It's a Numeric !",
 "It's a Alfa Numeric !"
 )
 )
 )
 }
)

Function to check if input is non-numeric or numeric

Top Replies