SUBSTITUTE

4D Online Documentation Center

Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com

4D View Pro Handbuch
- Formeln in 4D View Pro
- - Operatoren und Werte
  - Zellenreferenzen
  - Formeln vom Plug-In 4D View konvertieren
  - 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

Home

4D v19

4D View Pro Handbuch

Formeln in 4D View Pro

SUBSTITUTE

SUBSTITUTE


	SUBSTITUTE ( str , toReplace , replacement {, instance} )

	Parameter		Typ				Beschreibung
	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		Zahl				Which occurrence of the existing string to replace; otherwise every occurrence is replaced

Beschreibung

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.

Beispiel

SUBSTITUTE("Hello You","You","World") //Hello World

Vorige Seite

EIGENSCHAFTEN

Produkt: 4D
Thema: Formeln in 4D View Pro

SEITENINHALT

Beschreibung

Beispiel

GESCHICHTE

ARTIKELVERWENDUNG

4D View Pro Handbuch ( 4D v19)

© 1985-2025 4D SAS / 4D, Inc. Alle Rechte vorbehalten.

Fehler melden