First word transform function

Introduction

The first word transform function is used to extract the first word of an incoming string value, based on a user-defined delimiter. For example, you might have product data in a string:

{"first_fruit":"apples,oranges,pears,grapes"}

...and need to extract just the last item in the string for pushing to the destination system:

{"first_fruit":"apples"}

In this case, items in our source string value are delimited with a comma, so we can use this to determine the first word. The transform checks incoming string values and determines the 'first word' to be the word after the first occurrence of the given delimiter.

Adding a first word transform

Step 1 In your process flow, access settings for your map shape:

Step 2 Select the add transform icon for the required mapping rule - for example:

Step 3 Click the add transform button:

Step 4 Click in the name field to access a list of all available transform functions, then select first word from the string category:

Step 5 In the delimiter field, enter the character that delimits elements in the string:

If you use any of the following characters, they should be escaped: . + * ? ^ $ ( ) [ ] { } | \ /

For example, a delimiter of * would be entered as:

\*

A space is a valid character.

Step 6 Click the add field button:

Step 7 Click in source fields and select the source field to be used for this transform:

Step 8 Accept your changes (twice):

Step 9 Save the transform. You'll notice that the transform icon is updated to indicate that a transform function is present for the mapping row - for example:

Last updated