09-16-2008 7:42 PM
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
09-16-2008 7:52 PM
Try this:
CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.
Bye.
Andrew83
Edited by: Andrew83 on Sep 16, 2008 8:59 PM
09-16-2008 7:52 PM
Try this:
CONCATENATE Plant Plantdesc companycode INTO value RESPECTING BLANKS.
Bye.
Andrew83
Edited by: Andrew83 on Sep 16, 2008 8:59 PM