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




-there was a fishingbob on the floor

-this is a sentence with tombobjust stuck in the middle


Any ideas?


-Jim H