> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.stock-sync.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).
# Find and replace in matching column
The Find and Replace feature allows values in a mapped column to be **changed, converted, or rephrased** before they are matched or updated in the store. This is commonly used to clean up data, standardize naming, or remove unwanted text from feed values.
||| If get an error "Find words fail regular expression check." Click [here](https://stocksync.crisp.help/en/article/why-am-i-getting-an-error-as-find-words-fail-regular-expression-check-please-contact-our-support-team-xjhu8z/) to know more.
# 1. Find
Use this field to search for one or more words or phrases from the feed file.
* Multiple words or phrases can be added and separated by commas.
* The search matches **any part of the word**, not exact matches only.
* Supports **wildcards (*)** and **regular expressions**.
* Regular expressions can be tested here: https://regex101.com/
# 2. Replace with
Use this field to replace the words or phrases found in the **Find** field.
* Replacement values should follow the same order as the Find values.
* Multiple replacement values can be separated by commas.
### Examples
**(a)** To find words such as **woman**, **manicure**, or similar variations, use a wildcard pattern like: ***man**
This matches any word that starts with **man**.
**(b)** To add **multiple search conditions**, separate each value with a comma.
**(c)** If the value contains a **comma**, wrap the text in **double quotes (" ")** and use **[,]** to represent the comma. Examples: **"Clothes[,]"** , "mm[,]"
**(d)** To remove all links from a description field, use the following patterns in the Find field: *,,*
**(e)** To replace text using the value from another column, use the column name inside double curly brackets. Example: **{{Description}}**
