topic Re: how to get numeric part from a string. in Application Development and Automation Discussions

how to get numeric part from a string.

Former Member — Mon, 18 Oct 2010 12:43:29 GMT

Plz help me

how to get numeric part from a string.

Eg. 17682442basic

i want the numeric part from the field ( numeric field length not fixed)

Re: how to get numeric part from a string.

kesavadas_thekkillath — Mon, 18 Oct 2010 12:58:50 GMT

Ignore

Edited by: Keshav.T on Oct 18, 2010 6:37 PM

Re: how to get numeric part from a string.

Former Member — Mon, 18 Oct 2010 13:21:10 GMT

Hi,

Check the position of last character by using CA '0123456789'. And upto that position cut the string.

Amitava

Re: how to get numeric part from a string.

Former Member — Mon, 18 Oct 2010 13:26:44 GMT

I'd read the string left to right, one character at a time, until I found a character not in 1-9, by incrementing a counter and doing if string+counter(1) co '123456789'. etc.. When non-numeric character, the index (counter) is the length of the numeric part of the string.

Re: how to get numeric part from a string.

Former Member — Mon, 18 Oct 2010 13:29:14 GMT

Hi,

Try:

data: w_ss(10),
      w_nn type i,
      w_ii type i.

w_ss = '123abc'.
w_ii = 0.
while w_ii < strlen( w_ss ).
  if not w_ss+w_ii(1) ca '0123456789'.
     w_ss+w_ii(1) = ' '.
  endif.
  w_ii = w_ii + 1.
endwhile.
condense w_ss  no-gaps.

w_nn = w_ss.

write w_nn.

Best regards,

Lendro Mengue

Re: how to get numeric part from a string.

Former Member — Mon, 18 Oct 2010 13:32:13 GMT

Moderator message - Please do not ask or answer basic questions or questions that are easily searchable - thread locked Rob