SAP Data Services 4.x Cookbook

Using string functions

Here, we will explore a few useful string functions by updating our HelloWorld code to include some extra functionality. There is only one data type in Data Services used to store character strings, and that is varchar. It keeps things pretty simple for string-related and conversion operations.

How to do it…

Here, you will see two examples: applying string functions transformation within a dataflow and using string functions in the script object.

Follow these steps to use string functions in Data Services using the example of the replace_substr() function, which substitutes part of the string with another substring:

1. Open the DF_HelloWorld dataflow in the workspace window and add a new Query transform named Who_says_What. Put ...