replace all occurrence with range - issue

[Former Member]

Hi,

I have a range with "letters" like ":" or "-" or "."

Note: all entries are with option = "equal"

Now i need to "replace all occurrences" of "all entries in that range" with space.

idea:

loop at range assigning <range>.

replace all occurrences of <range>-low in aaa with space 
endloop. 

Any better ideas ?

Regards,

Gordon

[Former Member]

Hi,

I have a range with "letters" like ":" or "-" or "."

Note: all entries are with option = "equal"

Now i need to "replace all occurrences" of "all entries in that range" with space.

idea:

loop at range assigning <range>.

replace all occurrences of <range>-low in aaa with space 
endloop. 

Any better ideas ?

Regards,

Gordon

[ThomasZloch]

Maybe you can use

TRANSLATE aaa USING ': - . '.

instead.

Thomas

[Former Member]

HI,

i have to fill (policy) the "what is to be replaced"-values in a range.

any other ideas ?

Regards,

Gordon

[Former Member]

sorry, wrong post

Edited by: Rajesh on Feb 9, 2009 10:28 PM

previous reply deleted

[ThomasZloch]

Strange policy that. Well, you can convert your range values into the translation string and use TRANSLATE as shown, or just stick with your first idea and use REPLACE.

Thomas

[Former Member]

Sorry but i think my question was not clear.

is there another way instead of using the "loop" ?

The translate or replace statement is not the problem

thx,

Gordon

[tarangini_katta]

HI ,

Can you please give one reocrd of u r table.So that i can try to record.

Thanks