Skip to main content
Question

If field contains an alpha character

  • August 23, 2017
  • 0 replies
  • 45 views
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.
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement