topic Re: Problem with concatenation in Application Development and Automation Discussions

Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:34:25 GMT

Hi All,

I have 9 fields with different different lenghts. Now when I am trying to concatinate all the fields just values are concatenated which while displaying give improper results.

Now what I want is if two fields having length of 25 and 15 respectively so on concatinating it should display result as 40 whatever the length of value is there in these fields. Lets take example: -

Text1 = 'Problem' (Char 25)

Text2 = 'Solving' (Char 15)

then result should be 'Problem Solving '

I have already tried Respecting Blanks but it is giving me error saying in character mode or in byte mode or separated by expected.

<removed_by_moderator>

Edited by: Julius Bussche on Sep 8, 2008 12:20 PM

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:36:41 GMT

check...concatenate text1 text2 separated by space.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:38:18 GMT

Hi,

try this code-

Data:w_char(2) type c,

w_final type string,

w_text1(25) type c value 'Problem',

w_text2(15) type c value 'solved'.

Concatenate w_final w_text1 w_text2 into w_final separated by w_char.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:41:57 GMT

Hi Sidhhart,

This is Unicode problem.

You can use addition of IN CHARACTER MODE if all fields are of character data type.

CONCATENATE TEXT1 TEXT2 INTO TEXT3 IN CHARACTER MODE.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:44:22 GMT

Hi All,

Thanks for your replies but these strings get dynamic values. So you can't predict that how much length of value on that field is. Because of that I can't use any constant to fill spaces while concatinating.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:46:49 GMT

Hi,

Check the following statement

concatenate text1 text2 into w_final separated by space.

data: w_final type string.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:50:10 GMT

hii

just use statement like

Concatenate w_final w_text1 w_text2 into w_final separated by space

regards

twinkal

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 11:59:22 GMT

Hi,

data:
   Text1 type c length 25 value 'Problem',
   Text2 type c length 15 value 'Solving',
   text3 type string.

 CONCATENATE text1 text2
            INTO text3 separated by space.

            write: text3.

Regards,

Sravanthi

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 12:30:53 GMT

No Boss,

It is still displaying like 'Problem Solving' where as I am looking for

'Problem (18 spaces) Solving (8 Spaces)'

Please guide me with this.

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 12:32:10 GMT

Hi Siddarth,

This is Unicode problem.

You can use addition of IN CHARACTER MODE if all fields are of character data type.

Concatinate char1 char2 into result in character mode.

Thanks,

Ravi Kanth

Re: Problem with concatenation

JozsefSzikszai — Mon, 08 Sep 2008 12:33:09 GMT

Siddarth,

it is not Unicode problem and in this case you don't need to bother with concatenate, just use offset:

string = text1.

string+25 = text2.

string+x = ...

hope this helps

Re: Problem with concatenation

Former Member — Mon, 08 Sep 2008 12:40:34 GMT

CONCATENATE text1 text2
            INTO text3  respecting blanks.

Regards,

Sravanthi

Re: Problem with concatenation

Former Member — Mon, 19 Jan 2009 05:26:28 GMT

thanks for your comments