Ends With

[LDickenson]

Hi

I am trying to write a formula to do the following:-

if {matter.matter_description} endswith '(ACQ*)' then 'Acquisition' else
if {matter.matter_description} endswith '(SH*)' then 'South House' else
other

The field that I am testing has a descrption that at the end of the description always has something in brackets and this is what I need to test on.

Can anyone help please.

Thanks,

Lisa

 

[lbass]

Try something like:

if extractstring({matter.matter_description},"(",")") like 'ACQ*' then 'Acquisition' else
if extractstring({matter.matter_description},"(",")") like 'SH*' then 'South House' else
'Other'

If this doesn't meet your needs you should actual samples of your field, along with the expected formula results.

-LB