Replace PowerScript function

Description

Replaces a portion of one string with another.

Syntax

<span>Replace</span> ( <span>string1</span>, <span>start</span>, <span>n</span>, <span>string2</span> )

1	<span>Replace</span> ( <span>string1</span>, <span>start</span>, <span>n</span>, <span>string2</span> )

Argument	Description
string1	The string in which you want to replace characters with string2.
start	A long whose value is the number of the first character you want replaced. (The first character in the string is number 1.)
n	A long whose value is the number of characters you want to replace.
string2	The string that will replace characters in string1. The number of characters in string2 can be greater than, equal to, or less than the number of characters you are replacing.

Return Values

String. Returns the string with the characters
replaced if it succeeds and the empty string if it fails. If any
argument’s value is null, Replace returns null.

Usage

If the start position is beyond the end of the string, Replace appends string2 to
string1. If there are fewer characters after
the start position than specified in n, Replace replaces
all the characters to the right of character start.

If n is zero, then, in effect, Replace inserts string2 into string1.

Examples

These statements change the value of Name from Davis to Dave:

string Name

1	string Name

Name = "Davis"

1	Name = "Davis"

Name = <span>Replace</span>(Name, 4, 2, "e")

1	Name = <span>Replace</span>(Name, 4, 2, "e")

This statement returns BABY RUTH:

<span>Replace</span>("BABE RUTH", 1, 4, "BABY")

1	<span>Replace</span>("BABE RUTH", 1, 4, "BABY")

This statement returns Closed for the Winter:

<span>Replace</span>("Closed for Vacation", 12, 8, "the Winter")

1	<span>Replace</span>("Closed for Vacation", 12, 8, "the Winter")

This statement returns ABZZZZEF:

<span>Replace</span>("ABCDEF", 3, 2, "ZZZZ")

1	<span>Replace</span>("ABCDEF", 3, 2, "ZZZZ")

This statement returns ABZZZZ:

<span>Replace</span>("ABCDEF", 3, 50, "ZZZZ")

1	<span>Replace</span>("ABCDEF", 3, 50, "ZZZZ")

This statement returns ABCDEFZZZZ:

<span>Replace</span>("ABCDEF", 50, 3, "ZZZZ")

1	<span>Replace</span>("ABCDEF", 50, 3, "ZZZZ")

These statements replace all occurrences of red within
the string mystring with green.
The original string is taken from the SingleLineEdit sle_1 and
the result becomes the new text of sle_1:

long start_pos=1

1	long start_pos=1

string old_str, new_str, mystring

1	string old_str, new_str, mystring

mystring = sle_1.Text

1	mystring = sle_1.Text

old_str = "red"

1	old_str = "red"

new_str = "green"

1	new_str = "green"

// Find the first occurrence of old_str.

1	// Find the first occurrence of old_str.

start_pos = Pos(mystring, old_str, start_pos)

1	start_pos = Pos(mystring, old_str, start_pos)

// Only enter the loop if you find old_str.

1	// Only enter the loop if you find old_str.

DO WHILE start_pos &gt; 0

1	DO WHILE start_pos > 0

    // Replace old_str with new_str.

1	// Replace old_str with new_str.

    mystring = <span>Replace</span>(mystring, start_pos, &amp;

1	mystring = <span>Replace</span>(mystring, start_pos, &

      Len(old_str), new_str)

1	Len(old_str), new_str)

    // Find the next occurrence of old_str.

1	// Find the next occurrence of old_str.

    start_pos = Pos(mystring, old_str, &amp;

1	start_pos = Pos(mystring, old_str, &

      start_pos+Len(new_str))

1	start_pos+Len(new_str))

LOOP

LOOP

sle_1.Text = mystring

1	sle_1.Text = mystring

Connection Information

Replace – PB Docs 126