Find String in advanced experssion

[xiaoyao026]

hello everyone

i'm trying to use advance expression to achieve below 2 function, to get a value as 1 or 0, however, difficult to find a proper function to acheive this.

1st function:

A: MOTOR

B: WIPER MOTOR,RHD

how can i judge if string of A include in B, if yes, then return 1, else 0

2nd function:

A: 34

B: 34;53;54

how can i judge if value A can be found in B,  if yes, then return 1, else 0

thank you for advice in advance.

BR

[Reeza]

INDEXW and FINDW will work in both your cases.

[ballardw]

Your exampled may require more details for instance is

A: MOTOR considered found

 when

B: MOTORBOAT,RHD  (part of word)

or

B: WIPER motor,RHD  (case sensitive search)

or is

A: 34 considered found

when  

B: 345;53;54

IN