Splits a string into parts at a given delimiter and returns the specified part.
Syntax
SPLIT(“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
A Wall’s “Brick dimensions” Property is a string: “92mm x 57 mm x 194 mm”.
Use SPLIT to get just the second item (the width) from this string: split the string at the “x” delimiters and return the second part.
Expression
SPLIT (Brick Dimensions, “x”, 2)
Result
57 mm
Relevant topics
Split String to Left [SPLITLEFT]
Splits a string into parts at a given delimiter.
Returns the specified part and all parts to its left.
Syntax
SPLITLEFT (“Text”, ...
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 ...
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position.
Syntax
REPLACE ...