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.