Find and replace in matching column
If get an error "Find words fail regular expression check. Please contact our support team". Click here to know more.
Find multiple words or phrases separated by a comma. Search will match any word to find any part of the word, including *
Find field also supports regular expressions
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 multiple words or phrases separated by a comma. Search will match any word to find any part of the word, including *
Find field also supports regular expressions
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: 22/05/2024
Thank you!