Why is my Find replace transform not finding values as expected?

Trisha
Trisha
  • Updated

Issue

The Find replace transform in a Run schema expects numerical or regex values in the "Find" value and "Replace" value fields. This can cause issues if you would like to find a text value that uses protected regex values (regex reference).

Environment

Connect, Run schema

Cause

Because the "Find" and "Replace" value fields expect either regex or numerical values, these fields may not work as expected if you want to find a text value that uses any of the following protected regex characters: . ^ $ * + ? { } [ ] \ | ( )
 

Resolution steps

These characters can be escaped using a \ character. For example, to use a text string with "^", use "\^" instead.

Was this article helpful?

Have more questions? Submit a request