concatenate Issue.

[Former Member]

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

[Former Member]

Try this:

CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.

Bye.

Andrew83

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

[Former Member]

Try this:

CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.

Bye.

Andrew83

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