Discussions

Expand all | Collapse all

If field contains an alpha character

  • 1.  If field contains an alpha character

    Posted 08-23-2017 13:32
    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.


  • 2.  RE: If field contains an alpha character

    Posted 08-23-2017 14:00
    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.


  • 3.  RE: If field contains an alpha character

    Posted 08-23-2017 14:07
    Gotcha, thanks for the advice!