Used for: The "search in list" rule is used for searching for a value in a list and removing a value or counting how many of a value are in a list that match the input.
Used in: "THEN"-statements and "ELSE"-Statements.
Search in list: search value and delete
The "search value and delete" rule is particularly useful when you need to clean up your data by removing specific values from a list.
For example, if you have a list like "Nike", "Nike Pro", "Adidas", "Puma", this rule can refine it to just "Adidas", "Puma".
Note that the matching is not case-sensitive, so "nike" and "Nike" would be considered the same and both removed if specified.
This rule is beneficial when you want to ensure that only unique or relevant items remain in your list. This can be useful when your export channel needs specific brands excluded from your product listings, you can use this rule to remove those brands from your list before exporting.
Search in list: search value and delete others
The "search value and delete others" rule is similar to the "search value and delete" rule, but instead, it removes all non-matched elements from the list.
For example, if your list is "Nike", "Nike Pro", "Adidas", "Puma" and you want to only keep "Nike" and "Nike Pro", this rule will delete "Adidas" and "Puma" from the list.
This rule is not case-sensitive, assuring consistent matching regardless of capitalization.
Use this rule to refine your data by keeping only the specified values, making your lists more relevant and accurate.
Search in list: count value
The "count value" rule determines the specified values in a list and stores the result in a given field.
For example, in the list "Nike", "Nike Pro", "Adidas", "Puma", if "Nike" and "Nike Pro" are the matched values, this rule will result in the number being listed as "2".
This is beneficial for quickly determining the number of specific brands in your list and allows you to apply different rules using the newly added value.