I have a column of a 100 rows populated by variable length field comprised of alpha and numbers. The field contains part numbers. Every part number has ; towards the end of the field which is followed by 1,2, or 3 characters. I want to delete anything to the right of the ; including the ;. For instance part number ABC-1234-56;X4 I would like to only be ABC-1234-56.
Any direction appreciated (not an expert)
-j
Bookmarks