I need to strip (and not keep) characters from the right of a list of irregular strings. For example, in this string;



SCR SC207 MC3001 4W FIRE SUPP & EXT INSP STAT Rev 0';

I need to strip 'Rev 0' and retain the rest.

Note that strings in the list may NOT be all the same length.

I can strip from the left, but the right is proving to be tricky.

Thanks
Jon

It depends on what you have to strip!

a) certain number of characters;
b) certain substring (like " Rev 0'");
c) all starting with certain substring (like all starting with " Rev";
d) something else.

Thanks for your query.
I have figured it out. Thanks

Would you be so kind and show your solution for other people who would have the same problem and are looking for a helping hand.