Skip to main content
Question

Trim a text field

  • January 9, 2024
  • 0 replies
  • 198 views

I need to trim a text field that looks like this   PA-18-A150  i need to remove the second dash and everything to the right of it.  If I use the Trim function I get just the right or left.  the number of characters on both sides of the dashes vary so I cant use a specific number  of characters.



------------------------------
BR FlyStargate
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • January 9, 2024

    try this

    NotRight([My field],"-")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement