# 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  | <p>str \[System.String] – String to split</p><p>separator1 \[System.String] – Separator string 1 for parsing the string</p><p>separator2 \[System.String] – Separator string 2 for parsing the string</p><p>separator3 \[System.String] – Separator string 3 for parsing the string</p> |

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/WIuiWQYa1CGdI6MtuHwW/0.png)

**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* = -

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/IsmhgNNnyRpB0WFp6QdO/1.png)

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.

![](https://content.gitbook.com/content/zEifS4h8yurLAAwiGNX2/blobs/zmaIH6MDrI5GmkzqlRHf/2.png)