Skip to main content
Solved

How to use String Contains in Report Designer


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

The single quotation used as an apostrophe is closing the string too early.

Try this:

=InStr([ChangeRequest.TypeOfChange],’Sub-con\’s Proposal’)

View original
Did this topic help you find an answer to your question?

9 replies

ThasinduRanasinghe61
Jr Varsity I
Forum|alt.badge.img

@sathish80 you can use InStr( str, findStr ) function.

 In Expression Editor box >Functions > Text


  • Author
  • Freshman I
  • 9 replies
  • June 8, 2023

@ThasinduRanasinghe61 thank you your reponse, I already used this but i cannot use string with ‘single quotation’ InStr([ChangeRequest.TypeOfChange],’SubCon’sProposal’)

can you help me to solve this issue


darylbowman
Captain II
Forum|alt.badge.img+13

'SubCon’sProposal' is not the same as ‘Sub-con's Proposal’. Which one are you trying to find?


  • Author
  • Freshman I
  • 9 replies
  • June 8, 2023

I am trying ti find this one  ‘Sub-con's Proposal’.

 


darylbowman
Captain II
Forum|alt.badge.img+13

Then your formula should read:

InStr([ChangeRequest.TypeOfChange],’Sub-con’s Proposal’)

Can you confirm that it does?


  • Author
  • Freshman I
  • 9 replies
  • June 8, 2023

Thank you for your response 

I used following this got error missing operator before the operand

 

 


darylbowman
Captain II
Forum|alt.badge.img+13

The single quotation used as an apostrophe is closing the string too early.

Try this:

=InStr([ChangeRequest.TypeOfChange],’Sub-con\’s Proposal’)


  • Author
  • Freshman I
  • 9 replies
  • June 8, 2023

@darylbowman Thank you so mush its working fine now

 


darylbowman
Captain II
Forum|alt.badge.img+13

Sure thing


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings