This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
-
Operators and values
-
Cell references
-
Converting 4D View plug-in formulas
-
ABS
-
ACOS
-
AND
-
ASIN
-
ATAN
-
AVERAGE
-
COLUMNLETTER
-
COS
-
COUNTA
-
EXP
-
FALSE
-
FINDCELL
-
FV
-
IF
-
INDIRECT
-
ISBLANK
-
LEN
-
LN
-
LOOKUP
-
MAX
-
MID
-
MIN
-
NOT
-
NOW
-
NPER
-
OR
-
PI
-
PMT
-
PV
-
RAND
-
RATE
-
ROUND
-
ROW
-
RUNTIME_CURRENT_TIME
-
RUNTIME_DATE
-
RUNTIME_STRING
-
RUNTIME_TIME
-
RUNTIME_VIEW_STRING
-
SIN
-
SQRT
-
STDEV.P
-
SUBSTITUTE
-
SUM
-
TAN
-
TEXT
-
TODAY
-
TRUE
-
TYPE
-
VAR.P
-
4D v19
SUBSTITUTE
SUBSTITUTE
| SUBSTITUTE ( str , toReplace , replacement {, instance} ) | ||||||||
| Parameter | Type | Description | ||||||
| str | CellRef |
|
String or reference to a cell containing the string in which you want to replace characters | |||||
| toReplace | Text |
|
String to replace | |||||
| replacement | Text |
|
New string to use instead of existing string | |||||
| instance | Number |
|
Which occurrence of the existing string to replace; otherwise every occurrence is replaced | |||||
The SUBSTITUTE function replaces toReplace in the str text with replacement and returns the edited text.
By default, SUBSTITUTE replaces the first occurrence of toReplace. Pass instance to define which occurrence you want to replace.
If no occurrence of toReplace is found, SUBSTITUTE returns str.
SUBSTITUTE("Hello You","You","World") //Hello World
PROPERTIES
Product: 4D
Theme: 4D View Pro Formulas
PAGE CONTENTS
HISTORY
ARTICLE USAGE
4D View Pro Reference ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. All rights reserved.