topic Re: select last characters in Application Development and Automation Discussions

select last characters

Former Member — Thu, 28 Jun 2007 09:52:57 GMT

Hi.

In a fied i need the last 10 characters but i don´t know the leght of the field.

Any idea.

Thanks.

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:55:03 GMT

use describe statment to know the length of the field

DESCRIBE FIELD f

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:55:22 GMT

Hello,

Do like this.


data: char(20) value 'select last characters',
         len type i.
len  = strlen ( Char).
len = len - 10.
write: char+len(10).

Vasanth

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:56:26 GMT

get the length of the same using STRLEN.

subtarct the toatl length - 10.

then use the offset method and pass the value

then pass the val;ue of this as offset and value as 10

Regards

Shiva

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:57:08 GMT

data : len type i,

text(40) value 'abcdefghijklmon',

ntext(10).

compute len = strlen( text ).

len = len - 10.

ntext = text+len(10).

write : / ntext.

regards

shiba dutta

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:57:14 GMT

Hi,

Please try this FM ACEPS13_AWKEY_DECODE.

<b>Reward points</b>

Regards

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:57:35 GMT

Use the to STRLEN( <c> ).get the lenght of the field

lv_len = STRLEN( <c> ).

Re: select last characters

Former Member — Thu, 28 Jun 2007 09:59:55 GMT

The field is a type string and the content can to be variable.

Re: select last characters

jayanthi_jayaraman — Thu, 28 Jun 2007 10:02:09 GMT

Hi,

Check this can help you.

DATA: FLD(8),

LEN TYPE I.

DESCRIBE FIELD FLD LENGTH LEN IN CHARACTER MODE.

Result: LEN contains the value 8.

Re: select last characters

Former Member — Tue, 11 Sep 2007 15:04:33 GMT

REPEAT: The variable is a type string and the before code not is accept.

Re: select last characters

Former Member — Tue, 11 Sep 2007 15:34:18 GMT

HI,

This will work.. irrespective of the length..

data: char(20) value 'select last characters',

len type i.

len = strlen ( Char).

if len > 10.

len = len - 10.

write: char+len(10).

else

write char.

endif.

Thanks

Mahesh

Re: select last characters

Former Member — Tue, 11 Sep 2007 15:40:57 GMT

I modified Mahesh's code a bit:

DATA: char  TYPE string VALUE 'select last characters',
len TYPE i.
len = STRLEN( char ).
IF len > 10.
  len = len - 10.
  WRITE: char+len(10).
ELSE.
  WRITE char.
ENDIF.

Rob