instr

[#1]

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

[Former Member]

just going on from Abhilash

the result is the offset in the first string of the second string and 0 if it not in the first string.

put some sample data and simplify to instr(A$,B$)

abcdef def ( 4)

abcdef abc (1)

abcdef jjk (0 not found)

abcabc abc (1 the first )

instr("abcabc","abc",0) = 1

instr("abcabc","abc",2) = 4 ( this is not the second but starting from the second char)