AnsweredAssumed Answered

Making [Subsutite] non case sensitive

Question asked by jlhfbo on Nov 23, 2017
Latest reply on Nov 27, 2017 by jlhfbo

I have a calculation issue. Here is what I currently have:

=================

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

-bob

-there was a fishingbob on the floor

-this is a sentence with tombobjust stuck in the middle

 

Any ideas?

 

-Jim H

Outcomes