X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR BOOTSTRAP XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

VBScript Replace Function


VBScript Reference Complete VBScript Reference

The Replace function replaces a specified part of a string with another string a specified number of times.

Syntax

Replace(string,find,replacewith[,start[,count[,compare]]])

Parameter 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

Examples

Example 1

Replace the word "beautiful" with "fantastic":

<%

txt="This is a beautiful day!"
response.write(Replace(txt,"beautiful","fantastic"))

%>

The output of the code above will be:

This is a fantastic day!

Show Example »

Example 2

Replace the letter "i" with "##":

<%

txt="This is a beautiful day!"
response.write(Replace(txt,"i","##"))

%>

The output of the code above will be:

Th##s ##s a beaut##ful day!

Show Example »

Example 3

Replace the letter "i" with "##", starting at position 15:

Note that all characters before position 15 are removed.

<%

txt="This is a beautiful day!"
response.write(Replace(txt,"i","##",15))

%>

The output of the code above will be:

t##ful day!

Show Example »

Example 4

Replace the 2 first occurences of the letter "i" with "##", starting at position 1:

<%

txt="This is a beautiful day!"
response.write(Replace(txt,"i","##",1,2))

%>

The output of the code above will be:

Th##s ##s a beautiful day!

Show Example »

Example 5

Replace the letter "t" with "##", with textual, and binary, comparison:

<%

txt="This is a beautiful day!"
response.write(Replace(txt,"t","##",1,-1,1) & "<br />")
response.write(Replace(txt,"t","##",1,-1,0))

%>

The output of the code above will be:

##his is a beau##iful day!
This is a beau##iful day!

Show Example »

VBScript Reference Complete VBScript Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE

facebook