Tuesday, April 17, 2012

VBScript Replace Function

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":
<script type="text/vbscript">

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

</script>

The output of the code above will be:
This is a fantastic day!


Example 2

Replace the letter "i" with "##":
<script type="text/vbscript">

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

</script>

The output of the code above will be:
Th##s ##s a beaut##ful day!


Example 3

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

Note that all characters before position 15 are removed.
<script type="text/vbscript">

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

</script>

The output of the code above will be:
t##ful day!

Example 4

Replace the 2 first occurences of the letter "i" with "##", starting at position 1:
<script type="text/vbscript">

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

</script>

The output of the code above will be:
Th##s ##s a beautiful day!


Example 5

Replace the letter "t" with "##", with textual, and binary, comparison:
<script type="text/vbscript">

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

</script>

The output of the code above will be:
##his is a beau##iful day!
This is a beau##iful day!
 

No comments: