10 Replies Latest reply: Jun 14, 2016 7:59 AM by Rico van Zyl RSS

    Wildcards within an IF statement in a Script

    Brian Joseph

      Hi everyone,

       

      I multiple IF statements for data scrubbing purposes.  I've tested one but when I use a wildcard it just doesn't work. It seems to ignore it or it tries to literally search for the asterisk within the field data. I also tried % character for a wildcard. No luck.

       

      If ([Make] = 'Mercedes', 'Mercedes Benz', [Make])

       

      If ([Make] = 'Mercedes*', 'Mercedes Benz', [Make])   (doesn't work)