Split Text
Splits delimited text and returns a specific portion based on an offset. Especially useful to split account combinations but can be used to split any text.
Parameter | Description |
---|---|
Value | Some text which has been concatenated using a delimiter e.g. an account combination like “01.100.7000”. |
Offset | Identify which portion of the text to return. |
Delimiter | Defaults to “.” if you leave this parameter blank but you can override it to any delimiter. |
Example =Split_Text(“01.100.7000”,2) will return the “100” portion of the text.