Replace
The Replace function returns a new string in which all occurrences of a specified String in the current string are replaced with another specified String.
Syntax :
Replace(string,find,replacewith[,start[,count[,compare]]])| Parameters | Description |
|---|---|
| string | Required. The string to be searched. |
| find | Required. The part of the string that will be replaced. |
| replacewith | Required. The replacement substring. |
| start | Optional. Specifies the start position. Default is 1. All characters before the start position will be removed. |
| count | Optional. Specifies the number of substitutions to perform. Default value is -1, which means make all possible substitutions. |
| compare | Optional. Specifies the string comparison to use. Default is 0. Can have one of the following values : 0 - vbBinaryCompare - Perform a binary comparison . 1 - vbTextCompare - Perform a textual comparison. |
Example :
s = replace("Test %u%","%u%","Bob")Result :
s = Test Bob