Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

concatenate Issue.

Former Member
0 Kudos

Hello friends,

I have 3 fields.

Plant(4).

Plantdesc(30).

companycode(4).

value(50).

I want to concatenate all the 3 in the same order.

But the concern is for eg if I have dont have the plantdesc it should leave 30 spaces and then put the company code.

Concatenate Plant Plantdesc companycode into value.

with the above statement if plant desc is blank it puts plant and company code together.

Now i am solving my issue using.

value+0(4) = plant.

value+4(30) = plantdesc.

value+34(4) = companycode.

Any faster way of doing it.

Ster

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Try this:

CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.

Bye.

Andrew83

Edited by: Andrew83 on Sep 16, 2008 8:59 PM

1 REPLY 1

Former Member
0 Kudos

Try this:

CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.

Bye.

Andrew83

Edited by: Andrew83 on Sep 16, 2008 8:59 PM