topic string operation extract numerical from string in Application Development and Automation Discussions

string operation extract numerical from string

arpit_shah — Wed, 11 Jun 2008 13:06:50 GMT

Hi Experts,

how to extract numerical from string,

suppose,

if string = 'D050S114D7067'

then i want the numerical data of string,

means o/p = 0501147067

if string = YG1100KWC32

then o/p should be 110032

how to extract numerical characters from string?

Regards,

Arpit Shah

Re: string operation extract numerical from string

Former Member — Wed, 11 Jun 2008 13:08:35 GMT

HI,

assign directly like below.


DATA: lv_string(10) VALUE 'C9A0041254',
lv_number(10) TYPE n.
 
lv_number = lv_string.
WRITE:/ lv_number.

rgds,

bharat.

Re: string operation extract numerical from string

BGarcia — Wed, 11 Jun 2008 13:21:37 GMT

Hello Arpit.

Using regular expressions, you can achieve that like this:


DATA: lv_string  TYPE string VALUE 'D050S114D7067'.
DATA: lv_pattern TYPE string VALUE '([0-9]+)'.
DATA: lv_result  TYPE string.
DATA: lt_result  TYPE match_result_tab.
DATA: ls_result  LIKE LINE OF lt_result.

FIND ALL OCCURRENCES OF REGEX lv_pattern IN lv_string RESULTS lt_result.
LOOP AT lt_result INTO ls_result.
  CONCATENATE lv_result lv_string+ls_result-offset(ls_result-length) INTO lv_result.
ENDLOOP.

Kind regards.

Re: string operation extract numerical from string

marcelo_ramos1 — Wed, 11 Jun 2008 13:57:44 GMT

Hi Arpit,

You can use Regular Expressions(REGEX) to do it.

"As of release 7.0, ABAP supports extended regular expressions in accordance with POSIX standard 1003.2. Regular expressions can be used after the addition REGEX of the statements FIND and REPLACE for searching in character strings."

Font SAP help.

Do as follow:


...

string = 'D050S114D7067'.

REPLACE ALL OCCURRENCES OF REGEX '[:A-Z:]' IN v_data WITH SPACE.

Now string = 0501147067.

I encourage you to always use regular expressions in your programs.

For more information about regular expressions see:

[www.regular-expressions.info|www.regular-expressions.info]

[Regular Expression on Wikpedia|en.wikipedia.org/wiki/Regular_expression].

Greetings.

Marcelo Ramos

Re: string operation extract numerical from string

marcelo_ramos1 — Wed, 11 Jun 2008 14:07:22 GMT

Arpit,

if your string variable may contain characters in Uppercase and Lowercase you can use the following syntax.


...

string = 'd050S114d7067'

REPLACE ALL OCCURRENCES OF REGEX '[:A-Za-z:]' IN v_data WITH SPACE.

Greetings,

Marcelo Ramos

Re: string operation extract numerical from string

arpit_shah — Fri, 13 Jun 2008 10:55:38 GMT

Hi Bharat,

sorry, i hv write something different,

but my requirement is,

if string = 'D050S114D7067'

then i want the numerical data of string,

i want to split after numerical if any character is found.

means o/p should be = 050

if string = YG1100KWC32

then o/p should be 1100.

Re: string operation extract numerical from string

arpit_shah — Fri, 13 Jun 2008 11:17:15 GMT

i hv do it myself....

first i hv taken all numercal data and after that take first 2 character.

thanks and rgds,

Arpit