7 Replies Latest reply on Jun 15, 2018 11:39 AM by Simon Runc

    help with splitting an inconsistent string?

    rachel.kell.1

      i have a field of building names and I need to make them shorter so my map is all purty....

       

      essentially the format is BUILDING NAME - ROOM AND ROOM DESCRIPTION and I want to remove everything after the dash

       

      the issue is that some buildings start with numbers, and some don't, and some are in this form: 11-20 STREET NAME and some even have dashes between the room and room description (!!!)

       

      i've tried a bunch of split variations and i'm pulling my hair out.

       

      any help is appreciated!