Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
2 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
      2 years ago

      Thanks!!



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