topic Re: Replace letters and numbers in Application Development and Automation Discussions

Replace letters and numbers

Former Member — Wed, 16 May 2007 07:49:26 GMT

Hi,

Is there any variant of command Replace or other command to replace on a field all letters by “A” and all numbers by “1”?

Thanks in advance,

Nuno

Re: Replace letters and numbers

Former Member — Wed, 16 May 2007 07:51:35 GMT

Hi,

use this :

REPLACE ALL OCCURENCES OF 'A' IN field WITH '1'.

Hope this is what you wanted

Re: Replace letters and numbers

Former Member — Wed, 16 May 2007 07:54:19 GMT

data str type string value 'BACADA......ZA'

translate field with str. "this will replace all letters (B-Z) with A

do similarly with the numbers (use type n )

regards,

Priyank

Re: Replace letters and numbers

Former Member — Wed, 16 May 2007 07:55:22 GMT

Hi Shailesh,

not exacly...

what I need is: all letters are replaced by “A” and all numbers by “1”

ex:

BANKN (Bank account) is FS-012345.12

after the replace it should be AA-11111.11

Re: Replace letters and numbers

Former Member — Mon, 21 May 2007 12:46:37 GMT

Hi Priyank,

It doesn't seems to work... any other suggestions?

Thanks in advance,

Nuno

Re: Replace letters and numbers

Former Member — Mon, 21 May 2007 12:51:40 GMT

hi,

goto edit -> click on find/replace -> giv nam to be replaced -> continue ->ok

if helpful reward some points.

with regards,

suresh babu aluri.

Re: Replace letters and numbers

Former Member — Mon, 21 May 2007 12:55:55 GMT

Hi nuno,

1. <b>FS-012345.12 -

> AA-111111.11</b>

2. Just copy paste

report abc.

*----

data : s1(15) type c.

data : s2(15) type c.

data : ch(26) type c.

data : nu(10) type c.

data : ln type i.

data : pos type i.

*----

ch = sy-abcde.

nu = '0123456789'.

s1 = 'FS-012345.12'.

s2 = s1.

ln = strlen( s2 ).

do ln times.

pos = sy-index - 1 .

if ch CA s2+pos(1) .

s2+pos(1) = 'A'.

endif.

if nu CA s2+pos(1) .

s2+pos(1) = '1'.

endif.

enddo.

*----

write 😕 s1.

write 😕 s2.

regards,

amit m.