Hi I need to do a script in which will take characters off of a string for example:
if i have 1234-56/protrac i need to keep the 1234-56 and just delete the /protrac. so how can I do a script in which will constantly just remove the last 8 characters???
Your help is much appreciated. I know how to make it take off the last characters like this:
Field1 = SUBSTRING(field1, 1, 7)
but i am unsure that it will always be a 7 character number. So I need something that will automatically remove the / and the characters after it.