Split String [SPLIT]

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

  • Was this Helpful ?
  • YesNo
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”, ...
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position. Syntax REPLACE ...