I have a column of alphanumeric data with sections seperated by hyphens. I need to scrape the text after the last hyphen - but there are a variable number of hyphens in the field.
Example:
Thanks again!
Example:
LOCATION |
LINCOLN (WING01-FLR01-RM15-LAPTOP) |
SIOUX CITY (WING02-FLR03-RM27-SEAT2-PHONE) |
FRAMINGHAM (WING01-FLRB2-RM52-AUDTITORIUM-SEAT2-CEILING-PROJECTOR) |
Thanks again!