Hi everyone, How to use string contains function in report designer, If I saved string list in the particular field means How can check particular string is there or not
My field Name TypeofChange
Field Value = Design; Sub-con's Proposal;
My question is ‘Sub-con's Proposal’ string is available or not in the particular string field
Best answer by darylbowman
View original
In Expression Editor box >Functions > Text
can you help me to solve this issue
+11
'SubCon’sProposal' is not the same as ‘Sub-con's Proposal’. Which one are you trying to find?
I am trying ti find this one ‘Sub-con's Proposal’.
+11
Then your formula should read:
InStr([ChangeRequest.TypeOfChange],’Sub-con’s Proposal’)
Can you confirm that it does?
Thank you for your response
I used following this got error missing operator before the operand
+11
The single quotation used as an apostrophe is closing the string too early.
Try this:
=InStr([ChangeRequest.TypeOfChange],’Sub-con\’s Proposal’)
+11
Sure thing
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
