Trim a text field

Question

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 · Answer

try this
NotRight([My field],"-")------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Trim a text field

1 Reply