Skip to Content
0
Former Member
Aug 21, 2008 at 01:36 PM

removing last 2 characters from string field

2148 Views

I am trying to remove the last 2 characters of a string field.

there is no consistant length in the field

316R1

12364R1

i want to remove everything after R

i tried instrrev but i that didnt do it.

is there a way to say

start position1 and go the R

thanks