3 Replies Latest reply on Mar 29, 2016 7:28 AM by Adam Edwards

    Lookup table - captured values

    firuze

      Hi,

      I am trying to clean contact data field "industry" by running update rule for a number of contacts in a shared list. The update rule is set to find bad values in the fields and replace them with the good values as configured in the lookup table.

      I want to not only find the matching bad values that are exactly the same values as in the bad value list, but also that include the word between " * ".

      I guess this is not possible, do you know another way to capture the values that include a specific word?

       

      For ex. I would like to replace all values that contain "cosmetic" in their Industry field, however the lookup table only captures the field when the value is exactly "cosmetic" and does not capture fields with values like "cosmetics" or "cosmetic goods", "cosmetic all" etc.

       

      Thanks,

      Firuze