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”)
Relevant topics
String from Left [LEFT]
Returns a specified number of characters from the start of a text string.
Syntax
LEFT (“Text”, NumberOfCharacters)
...
Split String [SPLIT]
Splits a string into parts at a given delimiter and returns the specified part.
Syntax
SPLIT(“Text”, “Delimiter”, ...
Split String to Right [SPLITRIGHT]
Splits a string into parts at a given delimiter.
Returns the specified part and all parts to its right.
Syntax
SPLITRIGHT ...