Replacing characters, words, or phrases
You've probably used the find and replace function many times before when editing a document in Microsoft Word or Google Docs, a spreadsheet in Microsoft Excel or Google Sheets, or a database such as Smartsheet or Airtable. It does what the name says – finds something and then replaces it with something else. Zapier uses similar functionality, allowing you to find and replace words and phrases in text strings. You can use the Formatter by Zapier Text action event with the Replace transform function to achieve this. Microsoft Excel users will recognize the similarity of this Zapier functionality to the REPLACE or SUBSTITUTE formulas in a Microsoft Excel spreadsheet to find and replace text.
The Replace transform function also allows you to find special characters using special character syntax as follows: