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”, “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”)

  • Was this Helpful ?
  • YesNo
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”, ...