replacea PowerHome formula function
Description
Replaces a portion of one string with another.
Syntax
replacea ( string1, start, n, string2 )
| Argument |
Description |
|
string1
|
The string in which you want to replace bytes with string2
|
|
start
|
A long whose value is the number of the first byte you want replaced. (The first byte in the string is number 1)
|
|
n
|
A long whose value is the number of bytes you want to replace
|
|
string2
|
The string that will replace bytes in string1. The number of bytes in string2 can be greater than, equal to, or fewer than the number of bytes you are replacing
|
Return value
String. Returns the string with the bytes replaced if it succeeds and the empty string ("") if it fails.
Usage
If the start position is beyond the end of the string, Replace appends string2 to string1. If there are fewer bytes after the start position than specified in n, Replace replaces all the bytes to the right of character start.
If n is zero, then in effect Replace inserts string2 into string1.