How to select a string variable based on a part of the contents of this variable

[puttemans]

Hi,

I've got a string variable that basically contains 4 values ('coach', 'motor fuel', 'motor electrical' & 'other'). I want to select only the lines that contain the word 'motor' with a 'where' statement. I've tried the */~ & match routes, but without succes. Could anyone tell me which statement or character I should use to get all 'motor' lines selected?

Regards,

[Anonymous · Accepted solution]

Johan

Have you tried the WildMatch() function ?

Best Regards,     Bill

[puttemans]

Thank you, this works 🙂