topic How to extract string from ulphanum string.... in Application Development and Automation Discussions

How to extract string from ulphanum string....

naveenvishal — Fri, 14 Dec 2007 07:08:22 GMT

How can i extract the Alpha chars from the following string:

eg.

0900000101135ABC

0900000101135DEFG

Is there a std fn mod for extracting ABC and DEFG from the above strings..???

Output

ABC

DEFG

Nkrish — Fri, 14 Dec 2007 07:49:44 GMT

Hi,

You can use : STRING_SPLIT_AT_POSITION function module.

give value of string as the value provided. e.g 0900000101135ABC

give the position as the data size. I assume that the 90.... is a billing document number or a material document number.

So you can give the size as data size of document number,

Regards,

Narayani

Former Member — Fri, 14 Dec 2007 07:56:13 GMT

Hi Naveen

In case you do not find a FM then try this pseudo code...

cnt = 0.

DO 10 TIMES.

replace all occurences of cnt in your string with space. "please chk the right syntax for replace

cnt = cnt + 1.

ENDDO.

condense to remove spaces.

rainer_hbenthal — Fri, 14 Dec 2007 08:06:49 GMT

  FIND ALL OCCURRENCES OF REGEX '(D*)'
    IN '0900000101135ABC' SUBMATCHES s1.

  write:/ s1.