Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
12 months ago

"Ends with" Filter Solution

Hello Community,

How would you find a text field where all records end with a dash?  "-"
Most fields do not end with a dash.

I notice Quickbase does not offer the "ends with" as a filter, there is a "begins with" filter. Any ideas? 

Thanks,



------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------

2 Replies

  • np :)

    I assume that you were talking about a report filter?
    Just make a helper field called [Ends with Dash?]

    Ends([My field[], "-") 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JimHarrison's avatar
      JimHarrison
      Qrew Champion

      Thanks!!



      ------------------------------
      Jim Harrison
      transparency = knowledge + understanding : The Scrum Dudes
      ------------------------------