Skip to main content

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

 

 

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

 In Expression Editor box >Functions > Text


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

can you help me to solve this issue


'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’.

 


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

 

 


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

Try this:

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


@darylbowman Thank you so mush its working fine now

 


Sure thing


Reply