Forum Discussion

BRFlyStargate's avatar
BRFlyStargate
Qrew Member
11 months ago

Trim a text field

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    11 months ago

    try this

    NotRight([My field],"-")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------