topic Re: Replacing single quotes in Application Development and Automation Discussions

Replacing single quotes

Former Member — Fri, 04 Aug 2006 18:30:47 GMT

Hi All,

I am trying to get rid of single quotes ie, ', from my text field and replace it with blank, any idea how the code should look like, double quotes have no issues , '"', works but what to write anout single quotes,''' doesnt work.

Sorry , if it sounds very easy, may be I am missing out soemthing.

Thanks in Advance

Tina

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 18:38:03 GMT

Hi Tina, ABAP is a little funny when dealing with single quotes. Check the following program, notice that for one single 'quote, we need to use 2 and then of course wrap with quotes which give you a total of 4.



report zrich_0001.


data:  text type string.

text = 'This is a string with a '' in it, lets get rid of it'.


replace '''' with space into text.


write:/ text.

Regards,

Rich Heilman

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 18:46:20 GMT

HI,

see the below program

REPORT  Y_TEST.

data: text(10).
text =  'sudh''eer'.
write: text.

replace '''' with SPACE into text.

write:/ text.

Thanks

Sudheer

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 18:57:33 GMT

Hey , what if my character i 'subh'eer'?

and I want to get rid of ' in the middle.

thanks in advance.

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 18:59:09 GMT

Hi tina,

if u want to pass a string with single quote to a variable say 'text's' to v_data it considers the first occurence of ' after t as the end of the text and it gives u a syntax error.

data: v_data type string value 'text's'.

error: unable to interpret s after '.

hope this helps.

regards,

keerthi.

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:03:21 GMT

In the ABAP command if you wish to use single quotes a single quote previous to it indicates that you wish to enter a single quote.

REPLACE l_string with ''' '.

means replacing the first occurence of single quote to space. Surely if you wish to replace mulitple occurence better use TRANSLATE.

Regards

Anurag

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:09:41 GMT

hi tina,

try using the Translate command with which u can replace all the occurences..

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:42:00 GMT

Hi All ,

thanks for your help.

I meant my work area is holding value like

wa = "ajsja"xaj'asa . These are all values.

if wa-txt ca '"'.

REPLACE all occurrences of '"' in wa-txt WITH space.

endif.

if wa-txt ca `'`.

REPLACE all occurrences of `'` in wa-txt WITH space.

endif.

Shoud this not work.?

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:45:10 GMT

I feel the below would give syntax error.

if wa-txt ca `'`.

REPLACE all occurrences of `'` in wa-txt WITH space.

endif.

try using

if wa-txt ca `''`.

REPLACE all occurrences of `''` in wa-txt WITH space.

endif.

Regards

Anurag

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 19:46:02 GMT

No, the second statement will not work. You must have a total of 4 quotes there. The first one where you are looking for double quotes will work fine. The second must be like this.

if wa-txt ca ''''.
REPLACE all occurrences of '''' in wa-txt WITH space.
endif.

Regards,

Rich Heilman

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:49:23 GMT

Hi,

This statement works, the second one is tild ` and not', also I ran in debug mode, one issue is it does not insert spaces , it remves the character just. I actually wanted aga'aah to aga aah.

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 19:50:54 GMT

You can not use tild, you must code it like above with all quotes, 4 of them.

Regards,

Rich Heilman

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 19:50:57 GMT

Anurag,

But I need to replace both " and ', so '"' is fine and for the other `'` should work.

thanks

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 19:53:30 GMT

Please use the following if you want to keep the space left vacant by the quote.



if wa-txt ca ''''.
translate wa-txt using ''' '.
endif.

Regards,

Rich Heilman

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 19:54:56 GMT

Take this program for example, it remove both single quotes and double quotes and leaves the spaces.



report  zrich_0002.

data: wa-txt type string.

wa-txt = '"This" aga''aah'.

if wa-txt ca '"'.
  translate wa-txt using '" '.
endif.


if wa-txt ca ''''.
  translate wa-txt using ''' '.
endif.

write:/ wa-txt.

Regards,

Rich Heilman

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 19:57:43 GMT

Ok, so tild doesn't work in 46c, but it definitly does work in a WebAS 7.0. Just tested, it works.



report  zrich_0002.

data: wa-txt type string.

wa-txt = `"This" aga'aah`.

if wa-txt ca `"`.
  translate wa-txt using `" `.
endif.


if wa-txt ca `'`.
  translate wa-txt using `' `.
endif.

write:/ wa-txt.

Regards,

Rich Heilman

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 20:20:35 GMT

Ok...it is nice to understand that ur prb is solved.

Regards

Anurag

Re: Replacing single quotes

Former Member — Fri, 04 Aug 2006 20:51:12 GMT

Rich,

In your example :

First one with out tild, if my character is '"This" aga'aah', its gives error.

Re: Replacing single quotes

RichHeilman — Fri, 04 Aug 2006 20:59:51 GMT

What is the error?

Regards,

Rich Heilman

Re: Replacing single quotes

Former Member — Wed, 09 Aug 2006 12:37:29 GMT

Hi,

The literals can be assigned only

1)between 2 single Quotes or as you have explored

2)between 2 tildas,

eg: 'HIII SSSSS'.

or _{HIII SSSSS}.

Now When u r assigning a string which contains single qoutes <b>(but not a pair of consecutive single qoutes )</b>say <HII' SS'> then the assignment is not possible by the first method as the compiler ont be able distinguish the actual end of the Assignment.It can be done by using the second method(As Rich had shown).

But When the string contains a pair of 2 consecutive single qoutes like <HI THIS IS ''SDN''>

then it can be done using the first Method.The actual data in the Variable will be then,

THIS IS 'SDN'.

If u use the second Method,the actual data will be

THIS IS ''SDN''.

The `` tells the compiler to consider the entire text as the contents.

Regards,

Samson

Message was edited by: Samson Moses