Replacing string with space

[Former Member]

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

[Former Member]

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

[raja_thangamani]

• 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

[RichHeilman]

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

[RichHeilman]

oops, Eswar already has one there for ya.

Regards,

Rich Heilman

[Former Member]

@ Rich

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

Kind Regards

Eswar

[RichHeilman]

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

Regards,

RIch Heilman

[Former Member]

@ Rich

More Examples ---> Better Understanding.

So i guess it is never a problem.:)

Hope our examples will help Mahendhar...

Kind Regards

Eswar

[Former Member]

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

[Former Member]

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