Desktop productivity for business analysts and programmers

Find String in advanced experssion

Reply
Occasional Contributor
Posts: 18

Find String in advanced experssion

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

 

 

Super User
Posts: 22,873

Re: Find String in advanced experssion

Posted in reply to xiaoyao026

INDEXW and FINDW will work in both your cases.

Super User
Posts: 13,084

Re: Find String in advanced experssion

Posted in reply to xiaoyao026

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

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 131 views
  • 0 likes
  • 3 in conversation