Searching Part Word Within A Free Text Field 1

[Sange]

I know this is probably very simple to do however I have been unsuccessful.

I'm using CR9 and one of the fields contains free text. I need to search for the words, "Matter Finalised" or "Finalised Matter". I figure if I can just look for the word "Final" then this shall cover the different ways it may be presented (including potential spelling mistakes and typing errors). I thought I could do this by using LIKE in my formula but this hasn't worked.

Is there another approach where I can look for the word "final" in a free text field using a formula. I would also need to take into account the different ways the word may be presented, ie. Final, final, FINAL.

 

[e11a]

I'm using version 8 and have done something similar using instr.

Create a formula with something like
instr({field name}, "final&quot > 0 or instr({field name}, "Final&quot > 0 or instr({field name}, "FINAL&quot > 0

If "final" is in the field it will return "true".

In details, format section, suppress enter the condition
{formula name}=false
to hide all items where "final" isn't in the field.

Ella

 

[Reebo99]

Use :

instr(lcase({field name}), "final&quot

Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly

 

[Sange]

Thanks so much for responding with your suggestions.

I tried both solutions but for some reason instr(lcase({field name}), "final&quot didn't pick up those records containing the word finalised. The formula suggested by Ella worked a treat though - thank you

 

[Reebo99]

Sorry, you were meant to add the >0, so :
instr(lcase({field name}), "final&quot > 0

Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly