Find and replace in matching column
If get an error "Find words fail regular expression check." Click here to know more.
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/
Replace the words or phrases that were used with Find above separated by a comma.
(a) If you would like to find woman, manicure etc from the feed file. You can use *man
(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 {{}}
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) 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: 07/03/2025
Thank you!