Replace Function
Updated: August 2009
Returns a string in which a specified substring has been replaced with another substring a specified number of times.
Replace(expression, find, replacewith[, start[, count[, compare]]])
Replace returns the following values:
|
If |
Replace returns |
|---|---|
|
expression is zero-length |
Zero-length string (""). |
|
expression is Null |
An error. |
|
find is zero-length |
Copy of expression. |
|
replacewith is zero-length |
Copy of expression with all occurrences of find removed. |
|
start > Len(expression) |
Zero-length string. |
|
count is 0 |
Copy of expression. |
The return value of the Replace function is a string, with substitutions made, that begins at the position specified by start and concludes at the end of the expression string. It is not a copy of the original string from start to finish.
The following example uses the Replace function to return a string:
' This is a binary comparison (because the last argument is omitted),
' so the comparison is case-sensitive.
' Returns ABC123def
Result = Replace ("ABC123abc", "abc", "def")
' This is a text comparison, so the comparison is case-insensitive.
' Returns def123def
Result = Replace ("ABC123abc", "abc", "def", 1, -1, vbTextCompare)