cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hi,

what value will be returned from the below, if the 2nd string is a part of the 1st one? and what value will be returned from the below, if the 2nd string is not a part of the 1st one?

instr({?Skill}, totext({vweShowAnswers.ANS_QId},0,"") )

Thanks & Best Regards

Edward

0 Likes
View Entire Topic
abhilash_kumar
Active Contributor
0 Likes

Hi Edward,

Well, if the second string is a part of the first one then the formula will return 1 otherwise it will return 0.

For Eg:

Instr("SAPBO","SA") //Returns 1

Instr("SAPBO","SB") //Returns 0

Hope this helps!

-Abhilash