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

/wp-content/uploads/2012/12/1search_169737.png

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

/wp-content/uploads/2012/12/2deletemapping_169738.png

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

/wp-content/uploads/2012/12/3searchreplace_169748.png

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

/wp-content/uploads/2012/12/4replace_169749.png

/wp-content/uploads/2012/12/5sqlquery_169750.png

Notice the query generated

Now execute the data flow job and review the log

/wp-content/uploads/2012/12/6executefinish_169751.png

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

/wp-content/uploads/2012/12/8viewresults_169752.png

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