REPLACE command using passed variable values does not work

[Former Member]

Hi SDN Community

Are you aware of the replace command not working when passing strings as opposed to a variable containing the string.

For example:

This works:

replace '>JUL 2008</a>' with I_TEXT_VALUE into

I_TEXT_VALUE_REPLACE.

This dosen't work:

replace I_TEXT_VALUE_MATCH with I_TEXT_VALUE into

I_TEXT_VALUE_REPLACE.

where I_TEXT_VALUE_MATCH = '>JUL 2008</a>'

where I_TEXT_VALUE = '>JUL 2008<BR>Actual</a>'

Thank you.

Simon

[Former Member]

hi,

see this link

also you can press F1 on Replace.

thanks

[Former Member]

Hi SDN Community,

The following method was used to derive the same outcome required as per the REPLACE command.

LEN_REPLACE = STRLEN( C_CELL_CONTENT ) - 12.

I_TEXT_VALUE_REPLACE = C_CELL_CONTENT.

• replace I_TEXT_VALUE_MATCH with I_TEXT_VALUE into

• I_TEXT_VALUE_REPLACE.

I_TEXT_VALUE_REPLACE = I_TEXT_VALUE_REPLACE+0(LEN_REPLACE).

CONCATENATE I_TEXT_VALUE_REPLACE I_TEXT_VALUE INTO

I_TEXT_VALUE_REPLACE.

C_CELL_CONTENT = I_TEXT_VALUE_REPLACE.

Thank you.

Simon

[sridhar_meesala]

>

> This dosen't work:
> 
>      replace I_TEXT_VALUE_MATCH with I_TEXT_VALUE into
>                  I_TEXT_VALUE_REPLACE.

Hi,

Try this. It works.

DATA: T(20),
I_TEXT_VALUE_REPLACE LIKE T,
I_TEXT_VALUE_MATCH(20) VALUE '>JUL 2008',
I_TEXT_VALUE(20) VALUE '>JUL 2008 Actual'.

I_TEXT_VALUE_REPLACE = T.

REPLACE I_TEXT_VALUE_MATCH WITH I_TEXT_VALUE INTO I_TEXT_VALUE_REPLACE.
WRITE / I_TEXT_VALUE_REPLACE.

Thanks,

Sri.