Removing Part of Code 1

[lars7]

Hi,
I need to remove part of a code in a field so that I can compare the rest with another code "PTB69REV1". The part I want to remove is always at the end but has a number that will always increase, ie, Rev, Rev1, Rev2, Rev3 up to Rev12 at the moment.

I have tried to replace the end of the code like:

Expr1: Replace(Replace(Replace([Local Job Reference],'rev',""),'rev1',""),'rev2',"")

but this only works for the first one and would always need to be amended as the Rev number grows.

Does anyone know the best way to solve this?

 

[PHV]

I'd try something like this:
Expr1: Left([Local Job Reference], InStr([Local Job Reference],'rev')-1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lars7]

Hi PH,

Works great, Cheers.