|
Description Syntax Return
Datatype Example Migration
Replace Function - Visual Basic 6.0
(VB 6.0) |
Returns a string in which a specified substring has
been replaced with another substring a specified number of times. |
|
Syntax: |
Replace(expression, find, replace[,
start[, count[, compare]]])
Parameter |
Description |
expression |
Required. String expression containing substring to replace. |
find |
Required. Substring being searched for. |
replace |
Required. Replacement substring. |
start |
Optional. Default 1. Position within expression where substring
search is to begin. |
count |
Optional. Default -1 (All). Number of substring substitutions
to perform. |
compare |
Optional. Default vbBinaryCompare (0). Numeric value indicating
the kind of comparison to use when evaluating substrings. |
|
Return Data type: |
|
String |
Example: |
Dim St as String
St = "Chennaiiq"
Statement |
Result |
Remark |
Replace(St, "n", "m") |
Chemmaiiq |
|
|
Replace(St, "N", "m") |
Chennaiiq |
|
|
Replace(St, "n", "M") |
CheMMaiiq |
|
|
Replace(St, "n", "m", 5) |
maiiq |
|
|
Replace(St, "n", "m", 4, 1) |
mnaiiq |
|
|
Replace("", "n", "m") |
|
Empty String |
|
Replace(null, "n", "m") |
Error |
Invalid use of null |
|
Replace(St, "", "m") |
Chennaiiq |
(Copy of Expression) |
|
Replace(St, "n", "") |
Cheaiiq |
|
|
Replace(St, "n", "m", 20) |
|
Empty String |
|
Replace(St, "n", "m", 1, 0) |
Chennaiiq |
|
 |
|
|
Migration from Visual Basic 6.0 (VB 6.0) to |
|
Replace Function in VB Script (VBS) |
|
Replace Function in JScript (JS) |
|
Replace Function in ASP (Active Server Page) |
|
Replace Function in PHP Script |
|
Replace Function in MS-Access |
|
Replace Function in MS SQL Server |
|
Replace Function in Oracle |
|
Replace Function in C Language |
|
Replace Function in C++ Language |
|
Replace Function in Foxpro |
|
Replace Function in Fortran |
|
Replace Function in MS Excel Sheet |
 |
|
|
|
|