topic replace all occurrence with range - issue in Application Development and Automation Discussions

replace all occurrence with range - issue

Former Member — Mon, 09 Feb 2009 16:40:28 GMT

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

Re: replace all occurrence with range - issue

ThomasZloch — Mon, 09 Feb 2009 16:52:52 GMT

Maybe you can use

TRANSLATE aaa USING ': - . '.

instead.

Thomas

Re: replace all occurrence with range - issue

Former Member — Mon, 09 Feb 2009 16:56:11 GMT

HI,

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

any other ideas ?

Regards,

Gordon

Re: replace all occurrence with range - issue

Former Member — Mon, 09 Feb 2009 16:58:25 GMT

sorry, wrong post

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

previous reply deleted

Re: replace all occurrence with range - issue

tarangini_katta — Mon, 09 Feb 2009 17:02:54 GMT

HI ,

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

Thanks

Re: replace all occurrence with range - issue

ThomasZloch — Mon, 09 Feb 2009 17:05:43 GMT

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

Re: replace all occurrence with range - issue

Former Member — Mon, 09 Feb 2009 17:30:43 GMT

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