Function to check if input is non-numeric or numeric

janakik

Following code will tell whether it's a Numeric, Alfa Numeric 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 !"
        )
      )
    )
  }
)

janakik

Following code will tell whether it's a Numeric, Alfa Numeric 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 !"
        )
      )
    )
  }
)

According to this code, the value "700117330" is numeric, but "7001173306" is not. Moreover, it does not handle leading zeroes.

Thanks for catching the edge case. It seems it's because the integer limit.

Awesome , This is the right Solution