topic Re: how to split pack code value from its description in Application Development and Automation Discussions

how to split pack code value from its description

Former Member — Sat, 11 Apr 2009 09:28:55 GMT

Hi experts,

I have a Pack Code value in master data as Pack Code value : 320 and Description : 20LT. I want to use actual value of Pack code ie 20 Ltrs. But I don't know how to split 20LT value into 20 & LT.I tried SPLIT function with SPACE but most of the values in MASTER DATA ARE WITHOUT SPACE. I am trying to write this code in BW3.5. Please help me..

Regards,

Priyanka Joshi

Re: how to split pack code value from its description

Former Member — Sat, 11 Apr 2009 09:38:14 GMT

is it that unit in the end will always be 2 digit?

Then you can do this way

len = strlen( des ) - 2.
field1 = des+0(len).
field2 = des+len(2).

provide with some test data if this is not the case.

Regards,

Lalit Mohan Gupta.

Re: how to split pack code value from its description

Former Member — Wed, 15 Apr 2009 03:24:26 GMT

I could solve the problem using SHIFT & SPLIT functions and some code in abap.