topic Re: Extracting partial string from a string - is it substring ? in Application Development and Automation Discussions

Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 03:21:25 GMT

Hi ... I am trying to extract partial string from a variable.

Some how, I am not able to find substring function per what describe here :

http://help.sap.com/abapdocu/en/ABENSUBSTRING_FUNCTIONS.htm

wa_date = '20090304120346'.

V_DATE = SUBSTRING( val = WA_DATE off = 0 len = 4 ).

V_MONTH = SUBSTRING( val = WA_DATE off = 5 len = 2 ).

V_DATE = SUBSTRING( val = WA_DATE off = 7 len = 2 ).

I got compile error ...

Am I doing the right thing ? Thanks.

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 03:28:56 GMT

Hello,

wa_date = '20090304120346'.

V_DATE = SUBSTRING( val = WA_DATE off = 0 len = 4 ).

V_MONTH = SUBSTRING( val = WA_DATE off = 5 len = 2 ).

V_DATE = SUBSTRING( val = WA_DATE off = 7 len = 2 ).

Try this


v_date = wa_date+00(04)
v_month = wa_date+04(02)
v_date = wa_date+06(02)

Hope its clear

Regards,

Mansi.

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 03:30:24 GMT

Hi Davidku,

I am not sure about the function that you have mentioned below.

But, you need to use the Offset concept to extract the substring you want.

Seach SDN with the keyword Offset. You will get what you wanted.

Thanks,

Babu Kilari

Re: Extracting partial string from a string - is it substring ?

uwe_schieferstein — Tue, 28 Apr 2009 03:30:46 GMT

Hello David

As you can see in the upper right corner of the Webpage you mention this function is available in

NW AS ABAP Release 711

Are you already working on (basis) release >= 7.10?

Regards

Uwe

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 03:31:22 GMT

Syntax is correct.

What error you are getting?

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 03:33:09 GMT

Hi...

Try



V_DATE = WA_DATE+0(4).
V_MONTH = WA_DATE+5(2).
V_DATE = WA_DATE+7(2).

Hope this helps...

Regdrs,

Chintan.

Edited by: Chintan_SAP on Apr 28, 2009 9:03 AM

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 05:05:26 GMT

Perfect ... it works. Thanks.

I am still confined to SQL server and Oracle type of programming.

Trying to find the function but it exist in another form.

V_DATE = wa_date+00(04).

V_MONTH = wa_date+04(02).

V_DATE = wa_date+06(02).

This method is known as offset ?

Re: Extracting partial string from a string - is it substring ?

Former Member — Tue, 28 Apr 2009 05:06:56 GMT

Yes. That is the Offset Concept

Thanks,

Babu Kilari