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

    help with splitting an inconsistent string?


      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!