Forum Discussion

BRFlyStargate's avatar
BRFlyStargate
Qrew Member
5 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
------------------------------

1 Reply

  • try this

    NotRight([My field],"-")



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