topic Re: to extracte a value. in Application Development and Automation Discussions

to extracte a value.

Former Member — Tue, 02 Sep 2008 13:09:41 GMT

is there a simple way to extracte a string between to caracters ,

exemple i need ; " mydata " so i need to extract mydata.

thank you.

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 13:11:48 GMT

Hello,

You can use the SPLIT command.


Example: 
The text field text is separated at its blank characters, into the three strings str1, str2, and str3, and then into an internal table with the line type string. As the three strings are not sufficient for all seven parts, after the separation, str3 contains "drag it is getting old", while the internal table contains seven lines; one for each word in text. 
DATA: str1 TYPE string, 
      str2 TYPE string, 
      str3 TYPE string, 
      itab TYPE TABLE OF string, 
      text TYPE string. 
text = `What a drag it is getting old`. 
SPLIT text AT space INTO: str1 str2 str3, 
                          TABLE itab.

Regards.

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 13:12:49 GMT

One way is to use

REPLACE ALL OCCURENCES OF '"' with ''.

Hope this helps!

Regards,

Prashant

Re: to extracte a value.

JozsefSzikszai — Tue, 02 Sep 2008 13:13:17 GMT

sorry it is not absolutely clear for me, but if you want a leading and a trailing space, than you can do:

CONCATENATE space 'mydata' space INTO ... RESPECTING BLANKS.

-pls. note RESPECTING BLANKS is 6.0 syntax

hope this helps

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 13:15:23 GMT

Hi,

Using PATTERN also u can retrieve.

Regards,

Deepthi.

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 14:17:57 GMT

there is any other solution medata is between two caracters;

>mydata> so i need to Recover mydata.

thank you.

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 14:18:34 GMT

between

>mydata>

Re: to extracte a value.

Former Member — Tue, 02 Sep 2008 14:21:12 GMT

hi,

You can use condense statement

condense <variablename>

You can delete trailing spaces

regards

padma