O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required