topic Re: String Manipulation in Application Development and Automation Discussions

String Manipulation

Former Member — Thu, 18 Jan 2007 15:30:47 GMT

I need help with concatenating a string. I need to pad a field (material #) to 18 characters.

Here is the code:

No matter what I try, I lose the full length of matnr when I do the concatenation. It drops the trailing spaces.

data: v_tabkey like cdpos-tabkey.

data: v_matnr(18) type c.

move i_ekpo-matnr to v_matnr.

concatenate '010' v_matnr i_ekpo-werks into v_tabkey.

If i_ekpo-matnr = 'PET'. I get '010PET0010'. I need '010PET 0010'.

Thanks for any help.

Janet

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:33:32 GMT

concatenate '010' v_matnr into v_matnr.
concatenate v_matnr i_ekpo-werks into v_tabkey separated by space.

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:38:44 GMT

Hi,

data: v_tabkey like cdpos-tabkey.

data: v_matnr(18) type c.

move i_ekpo-matnr to v_matnr.

<b>

***********************************

Here you need to conver the material no conversion from External to Internal.use the Function module CONVERT_FIELD_TO_INTERN_FORMAT for that matrial field

************************************</b>

concatenate '010' v_matnr i_ekpo-werks into v_tabkey.

If i_ekpo-matnr = 'PET'. I get '010PET0010'. I need '010PET 0010'.

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:40:25 GMT

I need the full 15 spaces after PET to have the material number the full 18 characters.

Re: String Manipulation

RichHeilman — Thu, 18 Jan 2007 15:45:57 GMT

You might want to try using a place holder. Like so.......



move i_ekpo-matnr to v_matnr.
translate v_matnr using ' %'.

concatenate '010' v_matnr i_ekpo-werks into v_tabkey.

translate v_tabkey using '% '.

Regards,

Rich Heilman

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:47:27 GMT

Hi :

Use :

v_tabkey(3) = '010'

v_tabkey+3(18) = v_matnr.

v_tabkey+21(4) = v_werks.

In this situation you should have the 15 spaces !

Hope this helps,

Erwan

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:51:35 GMT

This didn't help. I still got a field back with a length of 3.

Re: String Manipulation

RichHeilman — Thu, 18 Jan 2007 15:54:39 GMT

If you have tried using the placeholder and it doesn't work. Please post the code there so that I can take a look.

Regards,

Rich Heilman

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:56:36 GMT

Hi Janet,

Please give the result needed ( v_tabkey ) with the actual example plz, because I don't understand...

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 15:57:32 GMT

Hi,

Use this,

concatenate '010' v_matnr space i_ekpo-werks into v_tabkey.

Regards,

Aman

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 16:06:40 GMT

Rich,

Thank you, again.

But I am confused. How does this command find the trailing spaces when the string length command doesn't?

Re: String Manipulation

RichHeilman — Thu, 18 Jan 2007 16:24:12 GMT

The TRANSLATE statement is simply translating the string, character by character, so where there is a SPACE is it replacing with a '%', this fills the rest of the V_MATNR with a character, then when concatenting, it uses all 18 characters, then you are simply transalating it back afterwards.

Regards,

Rich Heilman

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 16:31:38 GMT

Yep, I understood that. It is just strange that that appears to be the only command that is aware of the spaces.

Thanks again.

Re: String Manipulation

RichHeilman — Thu, 18 Jan 2007 16:33:23 GMT

The REPLACE statement will do it too.

Regards,

Rich Heilman

Re: String Manipulation

Former Member — Thu, 18 Jan 2007 16:56:58 GMT

Good to know.

Thanks.