topic Re: Concatenate two fields in Application Development and Automation Discussions

Concatenate two fields

Former Member — Tue, 06 Mar 2007 10:57:24 GMT

Hi,

I want to concatenate two fields into a target field. Both are of type character.

Now my Question is I want to concatenate these two fields without loosing trailing spaces.

for example ,first field is of length 20 and the sencond field is of lenth 15 characters.

Data : s1(20) type c,

s2(15) type c.

data : s3(40) type c.

S1 = 'sdn'.

S2 = 'network'.

concatenate s1 s3 into s3.

s3 should contain the contents like 'sdn network '.

after 'sdn' there are 17 spaces (20-3) and after 'network' there are 8 spaces(15-7).

Can u pls anyone suggest me on the same.

I tried using conversion exits, but for character type of fields , there will be no effect.

Regards,

Sujatha.

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 10:59:45 GMT

Hi Sujatha,

do like this

concatenate field1

` `

field2

` `

into v_target.

The Quotes you see are not normal ones. they are escape characters (The key above the TAB key n the keyborad.

Regards,

Ravi

Re: Concatenate two fields

rahulkavuri — Tue, 06 Mar 2007 11:00:42 GMT

try this way

Data : s1(20) type c,

s2(15) type c.

data : s3(40) type c.

S1 = 'sdn'.

S2 = 'network'.

concatenate s10(20) s20(15) into s3.

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:01:23 GMT

Try this:

s3 = s1.

s3+20 = s2.

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:01:28 GMT

Hi,

You can use ..

Condense field NO-GAPS.

Reward if you find this useful..

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:01:53 GMT

If you know the exact lengths , try this

report y_test1.

data : s1(20) type c,
s2(15) type c.
data : s3(40) type c.

S1 = 'sdn'.
S2 = 'network'.

s3+0(20) = s1.
s3+20(15) = s2.

write : s3.

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:02:11 GMT

Hello,


try like this
Data : s1(20) type c,
s2(15) type c.
data : s3(40) type c.

S1 = 'sdn'.
S2 = 'network'.
concatenate s1 ` `  s2 ` ` into s3.
write: s3

Vasanth

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:02:55 GMT

we have 'separated by' option for this..

concatenate s1 s2 into s3 separated by space.

reward if it helps u...

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:10:02 GMT

Hi Sujatha.

i thnk this will work..

Syntax

CONCATENATE {dobj1 dobj2 ...}|{LINES OF itab}

INTO result

[IN {BYTE|CHARACTER} MODE]

[SEPARATED BY sep]

[RESPECTING BLANKS].

for ur example

DATA : s1(20) TYPE c,

s2(15) TYPE c.

DATA : s3(40) TYPE c.

s1 = 'sdn'.

s2 = 'network'.

CONCATENATE s1 s2 INTO s3 RESPECTING BLANKS.

WRITE s3.

Regards

Srinivas

*Reward all Useful answers

Re: Concatenate two fields

Former Member — Tue, 06 Mar 2007 11:10:05 GMT

Hi,

Concatenate VAR1 VAR2 INTO VAR3 SEPARATED BY SPACE.

Regards,

Irfan