contains

[jschill2628]

I have a field that I need to decode, is there a way to the field, with out decoding each individual name. For example I have 2 separate building, one is call ABCD, and one is WXYZ, and they both have a department manager, denoted by DM. So currently it reads:

ABCD DM
WXYZ DM

Is there a way to write a formula so that it would pick up the DM, and I could change it to read Department Manager?

 

[fisheromacse]

if the 'DM' is always the last 2 characters, you could use:
//{@label}
IF RIGHT(TRIM({yourtable.deptfield}),2)="DM"
THEN "Department Manager"
ELSE "" //put whatever other value you would want between the quotes if you do not want it blank

 

[swiss2007]

Try
if "DM" in {yourfield} then "Deputy Manager" else