topic Re: SPACE Problem in Application Development and Automation Discussions

SPACE Problem

Former Member — Tue, 13 Feb 2007 07:57:14 GMT

Hi All,

I am having the following statement in the program .

I am inserting this data in the z table but when it is getting inserted a space is getting inserted at the beginning of the character.

For example if the value of lt_ct1-hierno is 1 , then ' 2' is getting inserted in the database ,

Please suggest how to remove it.

The statement i am using is

it_chng-hierno = lt_ct1-hierno + 1.

Thanks

Re: SPACE Problem

Former Member — Tue, 13 Feb 2007 07:59:21 GMT

Please specify the data type u are using for both.

If it is a string u have to CONDENSE the string before updating the table.

Re: SPACE Problem

Former Member — Tue, 13 Feb 2007 07:59:27 GMT

If it is a character field, then you can use the statement condense.

condense it_chng-hierno.

Regards,

Ravi

Re: SPACE Problem

Former Member — Tue, 13 Feb 2007 08:03:14 GMT

Manik,

CONDENSE it_chng-hierno [NO-GAPS.

EX;

DATA: STRING(25) VALUE ' one two three four',

LEN TYPE I.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

CONDENSE STRING.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

CONDENSE STRING NO-GAPS.

LEN = STRLEN( STRING ).

WRITE: STRING, '!'.

WRITE: / 'Length: ', LEN.

Output:

one two three four !

Length: 25

one two three four !

Length: 18

onetwothreefour !

Length: 15

Note that the total length of the field STRING remains unchanged, but that the deleted blanks appear again on the right.

Pls. MAek if useful

Re: SPACE Problem

Former Member — Tue, 13 Feb 2007 08:06:35 GMT

Hello Manik,

You can use the following statement:

SHIFT it_chng-hierno LEFT DELETING LEADING ` `.

CONDENSE it_chng-hierno.

Regards,

Beejal

**reward if this helps

Re: SPACE Problem

jayanthi_jayaraman — Tue, 13 Feb 2007 08:08:29 GMT

Hi,

it_chng-hierno = lt_ct1-hierno + 1.

pack it_chng-hierno to it_chng-hierno.

Pack will remove space if it is character.