Skip to Content
0
Former Member
Apr 03, 2007 at 02:34 PM

Subsring functionality

30 Views

Hi,

Information Line 1:

IF E1IDB02 BA-FIIKWAER = CNY

then MID(E1EDKA1 BE-NAME1,12,11)

IF E1IDB02 BA-FIIKWAER <> CNY and LEN(E1EDKA1 BE-NAME1)<=35

then MID(E1EDKA1 BE-STRAS,1,35)

IF E1IDB02 BA-FIIKWAER <> CNY and LEN(E1EDKA1 BE-NAME1)>35

then MID(E1EDKA1 BE-NAME1,36,35)

MID(E1EDKA1 BE-NAME1,12,11), If the total lenght NAME1 is ManoJ Kumar Musunuri and the the request is to pick the string from 11 to 22 lenghs, But the defined value is give is less than 22 lenght.

In these cases the a run time exception error is given. So my understanding is that the other total lenth of the field(ie.., 35characters) has to be entered atleast with spaces.

I would like to know if you have solution for this. Else we need to create a user defined function.

Manoj