Skip to Content

Trying out the Search Replace Function

This is a how to for the Search & Replace Function in Data Services 4.0 SP1

In your Data Flow, double click on Query Transform


Select title, and in mapping delete the expression CUSTOMER.CONTACTTITLE


Click the functions button, select String Functions, select Search_Replace and click Next


Enter data as shown below.  We’ll search for Accounting Manager and replace with Account Manager



Notice the query generated

Now execute the data flow job and review the log


Now review the results and notice that Account Manager has replaced Accounting Manager


You must be Logged on to comment or reply to a post.