SplitStringMultipleRecords (3 Separators)

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.