Can anybody help me to figure this out?

If the comments are stored line by line as below:

  
COUNTRY            CAR             MODEL                BODYTYPE          LINE  COMMENTS
ENGLAND            JAGUAR          V12XKE AUTO          CONVERTIBLE        01    XXXX 
				                                      02    YYYY
				                                      03    ZZZZ 

How do I display output like this?

 
COUNTRY          CAR              MODEL                BODYTYPE                COMMENTS
ENGLAND          JAGUAR           V12XKE AUTO          CONVERTIBLE             XXXXYYYYZZZZ

Thank you,

This message has been edited. Last edited by: JJ,

This isn't the most exciting example and I know that solutions have been posted before but I couldn't find them.

DEFINE FILE CAR
CARNAMETEXT/A1000V=LAST CAR||CAR;
END
TABLE FILE CAR
SUM CARNAMETEXT
BY COUNTRY
END

The trick is to use the variable format for the defined field.

Let us know if this works for you.

Your Comment field seems to have carriage return and might be too long

First check with datatype .. if that is ok
try this

CCMOT/A4000=CAR.COMMENT;
CCMOT1/A4000=CTRAN(4000, CCMOT, 59, 32, CCMOT1);

You will need to be careful of the size of the combined comment field.

How many comments could there be, and waht size is the field. If you go over 4000 characters, the you will have a problem.

DEFINE?

In lieu of a comments column in the CAR file, I used the STANDARD equipment column because there are multiple entries per car.

DEFINE FILE CAR
 CNTRY_CAR/A26 = COUNTRY | CAR ;
 COMMENT/A1000V = IF CNTRY_CAR NE LAST CNTRY_CAR THEN STANDARD ELSE ( LAST COMMENT | ' ' | STANDARD );
END
-*
TABLE FILE CAR
 SUM LST.COMMENT AS 'COMMENTS'
 BY COUNTRY
 BY CAR
-* BY STANDARD
END

It need have data all sorted using define else use compute?

Kofi

Thank you to all of you for your replies. I used Dan's method which is perfectly matched with my requirement.

Thanks again!