# 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  | <p>str \[System.String] – String to split</p><p>separator \[System.String] – Separator for parsing the string</p>   |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FEWwbDbsJGfJZtLHg48dV%2F0.png?alt=media)

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

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F3G2FieiTSVMp8HZqzed9%2F1.png?alt=media)

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.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FQrnnwS6SjiX5yEntc5yD%2F2.png?alt=media)