All Functions
Filter Function
FUNCTION: Replace( )
Replace
(String, FindSubstring, ReplaceSubstring,
Start, Count, Compare
)
The
Replace
function replaces a specified substring within a specified string with a new specified substring and returns the modified string.
There are three mandatory arguments.
String
The
String
argument is the string to be searched.
FindSubstring
The
FindSubstring
argument is the substring you are searching for inside the string.
ReplaceSubstring
The
ReplaceSubstring
argument is the the new substring string that you wish to insert inside the string.
Code:
<% =Replace("How now brown cow?", "brown", "purple") %>
Output:
How now purple cow?
There are three optional arguments.
Start
The optional
Start
argument specifies the position number, counting from the left, where you wish to start the search.
Note that the portion of the string to the left of the start position will be discarded.
Code:
<% =Replace("How now brown cow?", "brown", "purple", 7) %>
Output:
w purple cow?
Count
The optional
Count argument
specifies how many times to replace the substring.
Code:
<% =Replace("red blue red-blue redblue bluered", "blue", "purple", 1, 3) %>
Output:
red purple red-purple redpurple bluered
Compare
The optional
Compare
argument must only use either the constant or value of the COMPARISON CONSTANTS.
CONSTANT
VALUE
DESCRIPTION
VBBinaryCompare
0
Binary comparison
VBTextCompare
1
Text Comparison
VBDataBaseCompare
2
Compare information inside database
In the example, by using VBBinaryCompare, or 0, for the
Compare
argument, all upper/lower case differences are obeyed in both the search and replace.
Code:
<% =Replace("red blue red-blue redblue bluered", "BLUE", "PURPLE", 1, 3, 0) %>
Output:
red blue red-blue redblue bluered
In the example, by using VBTextCompare, or 1, for the
Compare
argument, all upper/lower case differences are ignored in the search and obeyed in the replace.
Code:
<% =Replace("red blue red-blue redblue bluered", "BLUE", "PURPLE", 1, 3, 1) %>
Output:
red PURPLE red-PURPLE redPURPLE bluered
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information