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