Vous êtes sur le site Web historique de la documentation de 4D. Les documentations sont progressivement déplacées vers developer.4d.com
- 4D View Pro
-
- Formules 4D View Pro
-
-
Opérateurs et valeurs
-
Références des cellules
-
Conversion des formules du plug-in 4D View
-
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} ) | ||||||||
| Paramètre | Type | Description | ||||||
| str | RefCell |
|
String or reference to a cell containing the string in which you want to replace characters | |||||
| toReplace | Texte |
|
String to replace | |||||
| replacement | Texte |
|
New string to use instead of existing string | |||||
| instance | Numérique |
|
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
PROPRIÉTÉS
Produit : 4D
Thème : Formules 4D View Pro
PAGE CONTENTS
HISTORIQUE
UTILISATION DE L'ARTICLE
4D View Pro ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. Tous droits réservés.