RSplit (String)

Name

RSplit

Syntax

RSplit (String str, Integer maxTokens, String delimiter, Integer returnToken)

Purpose

To split a string into chunks, specified by an integer value of a ‘maxTokens’ variable, and delimited by a ‘delimiter’ string value. Returns specified token at index ‘returnToken’, counting from the right. (Note: The integer value, 0, will return the first split chunk)

Description

Splits a string into a maximum ‘maxTokens’ tokens delimited by ‘delimiter’. Returns token at index ‘returnToken’ counting from the right.

Return Type

String

Parameters

str [System.String] – The string to be broken into tokens

maxTokens [System.Int32] – The maximum number of tokens to split the string into. -1 is taken to unlimited. The number should be greater than the index of the token to be returned

delimiter [System.String]

returnToken [System.Int32] – The index (Counting from right to left) of the token generating by splitting 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-G-H-I

maxTokens = 3

delimiter = - (Note: Since the string values in our case are separated using “-”, our delimiter value will also be “-”. This value can be replaced with other delimiters, depending on the data format)

returnToken = 2 (Note: We are using the value 2, as we want to return the third part of the split string, from the right)

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the third part of the split string, counting from the right.

Last updated

© Copyright 2023, Astera Software