11-28-2017 10:28 PM
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.
B: WIPER MOTOR,RHD
how can i judge if string of A include in B, if yes, then return 1, else 0
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.
11-30-2017 06:01 PM
Your exampled may require more details for instance is
A: MOTOR considered found
B: MOTORBOAT,RHD (part of word)
B: WIPER motor,RHD (case sensitive search)
A: 34 considered found