Find and replace in matching column
1. Find
Find for multiple words or phrases separated by commas. The search matches any part of the words, supports wildcard (*) and regular expressions. Test your regular expression here: https://regex101.com/
2. Replace with
Replace the words or phrases that were used with Find above separated by a comma.
Examples:
(a) If you would like to find woman, manicure etc from the feed file. You can use *man
(b) To add multiple conditions to the find field, separate them with commas.
(b) If you would like to find any part with a comma, It has to wrap with the double quotes " " and use this [,] in between the comma. etc: "Clothes[,]" , "mm[,]"
(c) To remove all links from the description field, enter below <a href=.?>,<a id=.?>,</a>
(d) To replace the words with the column name, use {{Description}} and place the column name inside the bracket {{}}
Updated on: 23/05/2025
Thank you!