SplitStringMultipleRecords

Name

SplitStringMultipleStrings

Syntax

SplitStringMultipleStrings (String str, String separator)

Purpose

To split a string into multiple parts along the specified separator strings and return results as separate records.

Description

Returns a structure containing individual string parts. This function returns a record for each part.

Return Type

String

Parameters

str [System.String] – String to split

separator [System.String] – Separator for parsing the string

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A/B/C/D/E/F

separator = /

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the different parts of the split string as separate records, on the basis of the specified delimiter (separator) value.

© Copyright 2023, Astera Software