Splits a string into parts at a given delimiter.
Returns the specified part and all parts to its left.
Syntax
SPLITLEFT (“Text”, “Delimiter”, PartIndex)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Text and Delimiter: String
Part Index: Integer
Data Type of the Result
String
Example
Given an ARCHICAD Element ID, such as TREAD-018 (a string-type data):
Get the part of the string that is on the left of the delimiter.
The delimiter, which separates the Element ID into parts, is a dash.
The part number (index) you want is 1 (the first part).
Expression
SPLITLEFT (Element ID, “-”, 1)
Result
TREAD (for an Element ID of “TREAD-018”)