SplitStringMultipleRecords (2 Separators)
Name | SplitStringMultipleStrings |
Syntax | SplitStringMultipleStrings (String str, String separator1, String separator2) |
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 |
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 = /
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.