SplitStringMultipleRecords (3 Separators)
Last updated
Last updated
Name
SplitStringMultipleStrings
Syntax
SplitStringMultipleStrings (String str, String separator1, String separator2, String separator3)
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
separator1 [System.String] – Separator string 1 for parsing the string
separator2 [System.String] – Separator string 2 for parsing the string
separator3 [System.String] – Separator string 3 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
separator1 = ?
separator2 = /
separator3 = -
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) values.