insert and replace value in the string in one shot?

[thelearner]

Hi,

<Cell ss:StyleID="s26"><Data ss:Type="String">&&*01</Data></Cell>

In the string above, I want to replace &&*01 with some data. Currently this is how I do this.

Temp = %REPLACE('':SourceString:I:5); // remove &&*01
Result= %REPLACE(MyData:Temp:I:0); //Insert data

( 'I' is the position that I found &&*)

Can I achieve the same result with one %REPLACE or any one operation code or buildin fxn?

Thank in advance.

 

[Mercury2]

SourceString="<Cell ss:StyleID="s26"><Data ss:Type="String">&&*01</Data></Cell>";

Result = %replace(SomeData:SourceString:%scan('&&*01': SourceString): 5);

 

[thelearner]

perfect! thank.