AnsweredAssumed Answered

Case sensitivity

Question asked by jlhfbo on Nov 23, 2017

Happy Thanksgiving to all...

 

I have a equation:

Substitute ( [TextField-A];

[CalculationField-B] ; TextColor ( Play Copy2; RGB ( 255; 0; 0)))

 

It is case sensitive in that when searching for "Bob" it will only return on "Bob." However, I need it to return on:

-He bobbed in the water

-Bob

-bob

-there was a fishingbob on the floor

-this is a sentence with tombobjust stuck in the middle

 

Any ideas?

 

-Jim H

Outcomes