|
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.