Substitute Strings [SUBSTITUTE]

Replaces a string with another string, in the specified instance (or all instances).

Syntax

SUBSTITUTE (“Text”, “OldText”, “NewText”, [InstanceIndex])

Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.

Data Types of the Arguments

All Texts: String

InstanceIndex (Optional): Integer

If InstanceIndex value is omitted, then all instances of the OldText are replaced.

Data Type of the Result

String

Example

A Wall’s “Brick dimensions” Property is a string: “92mm x 57 mm x 194 mm”.

Use SUBSTITUTE to extract just the numbers from this string (e.g. for use in another expression).

(For the OldText “mm” strings, substitute a NewText of nothing.)

Expression

SUBSTITUTE (Brick Dimensions, “mm”, “”)

The InstanceIndex is not provided. Thus, all instances of the OldText will be substituted.

Result

92 x 57 x 194

Notes

Use SUBSTITUTE to replace one string with another, in all instances or a particular instance.

Use Replace in String [REPLACE] to change a particular string to another string, with a given starting position.

  • Was this Helpful ?
  • YesNo
Relevant topics
Merge Strings [CONCAT]
Joins two or more text strings into one. Syntax CONCAT (“text1”, [“text2”], ...) Note: The required separator ...
Join Strings [TEXTJOIN]
Joins two or more text strings into one string, separated by a given delimiter. If IgnoreIfEmpty is True, the result will ignore empty ...
Curtain Wall Junctions
A Curtain Wall Junction is an optional structure that serves to connect panels to each other, to support or (more often) to substitute for Frames, ...