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

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.