8.4.58 Replace Function

Returns a string in which a specified substring has been replaced with another substring a specified number of times.
Syntax
Replace(expression, find, replacewith[, start[, count[, compare]]])
Arguments
- expression
- A string expression containing substring to replace. Required.
- find
- The substring being searched for. Required.
- replacewith
- The replacement substring. Required.
- start
- The position within expression where substring search is to begin. If omitted, 1 is assumed. Optional.
- count
- The number of substring substitutions to perform. If omitted, the default value is -1, which means make all possible substitutions. Optional.
- compare
- The numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. Optional.
Settings
The compare argument can have the following values:
Constant
|
Value
|
Description
|
vbBinaryCompare
|
0
|
Perform a binary comparison.
|
vbTextCompare
|
1
|
Perform a textual comparison.
|
Return Values
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 occurences of find removed.
|
start > Len(expression)
|
Zero-length string.
|
count is 0
|
Copy of expression.
|
Remarks
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.
Copyright © 2000 Chili!Soft
|