You can use the REPLACE transform to replace values within the specified column or columns based on the specified string literal, pattern, or position.
Using Replace Transform
From the top toolbar, select the REPLACE icon
Expand the menu to see the available options under Replace
Select Text or Pattern
It opens the Replace transform menu on the right side panel.
Here you can specify the column(s) to look into, the pattern to find and the replacement string as required.
For Example - Here we are Replacing '$ ' characters from the Items column with '#' character. The preview of the column shows the replacement being made.
You can also perform Replace transformation based on other criteria such as
Replace between Delimiters
Replace between Positions
Replace Missing values
Replace Mismatched values
To learn more about these options, read this documentation guide.
When designing the REPLACE transform step, click on Advanced Options to expand and see more available options, such as-
Start search after
Stop search after
Match all occurrences
to make your search and replace more effective.
To learn more about Replace transform, read this detailed documentation guide.