topic Re: Replacing string with space in Application Development and Automation Discussions

Replacing string with space

Former Member — Tue, 12 Dec 2006 01:30:04 GMT

Hi SDNers,

I have an address field of length 100.But it has single quotes ( ' ).

I have to replace the single quote with space...can anyone suggest me

how it can be done...am using (contains pattern) but unsuccessful.

Thanks

Mahendhar Reddy

Re: Replacing string with space

Former Member — Tue, 12 Dec 2006 01:32:55 GMT

Please try with <b>TRANSLATE</b> statement.

Please check this example:

parameters: p_text(10) type c.

translate p_text using ''' '.
write:/ p_text.

Kind Regards

Eswar

Re: Replacing string with space

raja_thangamani — Tue, 12 Dec 2006 01:33:47 GMT

Populate the Single Quotes with Space.



CONSTANTS: C_QUOTE_SNG TYPE C  VALUE ''''.

REPLACE ALL OCCURRENCES OF C_QUOTE_SNG IN V_STRING WITH SPACE.

THis will slve your problem.

<b>Note:</b> Reward each useful post.

Raja T

Message was edited by:

Raja T

Re: Replacing string with space

RichHeilman — Tue, 12 Dec 2006 01:41:52 GMT

As suggest earlier, use the TRANSLATE statement, here is an example.



report zrich_0001.


data: str type string.

str = '12345''67890''abcde'.

translate str using ''' '.

write:/ str.

REgards,

RIch Heilman

Re: Replacing string with space

RichHeilman — Tue, 12 Dec 2006 01:42:19 GMT

oops, Eswar already has one there for ya.

Regards,

Rich Heilman

Re: Replacing string with space

Former Member — Tue, 12 Dec 2006 01:43:07 GMT

Hi Mahendhar,

Try this:

DATA: text TYPE STRING.

text = 'abcdefgh'.

REPLACE 'd' IN text WITH 'XXXX'.

returns: text = 'abcXXXXefgh', sy-subrc = 0

Rewards if the above helps.

Cheers,

Patrick

Re: Replacing string with space

Former Member — Tue, 12 Dec 2006 01:46:52 GMT

@ Rich

Maybe you have missed out while i was editing my post...:)

Kind Regards

Eswar

Re: Replacing string with space

RichHeilman — Tue, 12 Dec 2006 01:48:22 GMT

I believe so, I was writing my example at that time

Regards,

RIch Heilman

Re: Replacing string with space

Former Member — Tue, 12 Dec 2006 01:59:49 GMT

@ Rich

More Examples ---> Better Understanding.

So i guess it is never a problem.:)

Hope our examples will help Mahendhar...

Kind Regards

Eswar

Re: Replacing string with space

Former Member — Tue, 12 Dec 2006 02:11:34 GMT

Vow...you guys are very helpful man...

Thanks a lot.yaah...examples have not only solved my prblm but

taught several other things..thanks again