I have a field of data that looks something like this: C320-EB-17-SOME NAME
I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same position every time. About the only thing I can count on is the SOME NAME coming directly after the last '-'
Any ideas?
I need to extract just the part that is SOME NAME. In Access I'd use INSTREV and search for '-' then do a left function from that point. The data is variable so I can't just count on SOME NAME starting at the same position every time. About the only thing I can count on is the SOME NAME coming directly after the last '-'
Any ideas?