Replace string

4D - Documentation   Français   English   German   Spanish   Japanese   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11.1 (Modified)


Replace string (source; oldString; newString{; howMany}{; *}) String

ParameterTypeDescription
sourceStringOriginal string
oldStringStringCharacters to replace
newStringStringReplacement string
(if empty string, occurrences are deleted)
howManyNumberHow many times to replace
If omitted, all occurrences are replaced
**If passed: evaluation based on character codes
Function resultStringResulting string

Description

Replace string replaces howMany occurrences of oldString in source with newString.

If newString is an empty string (""), Replace string deletes each occurrence of oldString in source.

If howMany is specified, Replace string will replace only the number of occurrences of oldString specified, starting at the first character of source. If howMany is not specified, then all occurrences of oldString are replaced.

If oldString is an empty string, Replace string returns the unchanged source.

By default, the command makes global comparisons that take linguistic particularities and letters that may be written with one or more characters (for example æ = ae) into account. On the other hand, it is not diacritical (a=A, a=à and so on) and does not take "ignorable" characters such as carriage returns into account (Unicode specification).

To modify this functioning, pass the asterisk * as the last parameter. In this case, comparisons will be based on character codes. You must pass the * parameter:

If you want to replace special characters, used for example as delimiters (carriage returns, Char(1), etc.),

If the replacement of characters must be case sensitive and take accented characters into account (a#A, a#à and so on).

Note that in this mode, the evaluation does not handle variations in the way words are written.

Examples

1. The following example illustrates the use of Replace string. The results, described in the comments, are assigned to the variable vtResult.

   vtResult:=Replace string("Willow";" ll";"d")  ` Result gets "Widow" 
   vtResult:=Replace string("Shout"; "o";"")  ` Result gets "Shut" 
   vtResult:=Replace string(vtOtherVar;Char(Tab);",";*)  ` Replaces all tabs in vtOtherVar with commas

2. The following example eliminates CRs and TABs from the text in vtResult:

   vtResult:=Replace string(Replace string(vtResult;Char(Carriage return);"";*);Char(Tab);"";*)

3. The following example illustrates the use of the * parameter in the case of a diacritical evaluation:

   vtResult:=Replace string("Crème brûlée";"Brulee";"caramel") `Result gets "Crème caramel"
   vtResult:=Replace string("Crème brûlée";"Brulee";"caramel";*) `Result gets "Crème brûlée"

See Also

Change string, Delete string, Insert string.


4D - Documentation   Français   English   German   Spanish   Japanese   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next