If field contains an alpha character

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a field that contains text values and I want to be able to filter a report to show only the records where the field does not contain alpha characters (i.e. only numbers and symbols).  My thought process at the moment is to create a calculated column to filter the report like this:

IF( 
  Contains([Field], "A") OR
  Contains([Field], "B") OR
  ...
  Contains([Field], "Z"),
"True", "False")

Obviously, this formula is not very elegant.  Does anyone know of a more efficient way to code this?

Thanks in advance.
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
Personally I would just brute force it like you planned and be done with it. Copy and Paste is your friend.

There is lots of horsepower to run your app so I would not worry about efficiency as you time is valuable to mess around with alternatives.  Gett'er workin' and move on.
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
Gotcha, thanks for the advice!