Hello,

I want to save the rows of a table with a single column into a string, the values separated by commas.

for example

TABLE FILE CAR
PRINT
CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE HOLD AS CARS
-RUN

the result will be:

JAGUAR
JENSEN
DATSUN
MASERATI
TOYOTA
AUDI
TRIUMPH
ALFA ROMEO
BMW
PEUGEOT

if i use -READ CARS &CAR.A20.
i only get the first record

What I need is to save these values in a string separated with commas like:

JAGUAR,JENSEN,DATSUN,MASERATI,TOYOTA,AUDI,TRIUMPH,ALFA,ROMEO,BMW,PEUGEOT

How can i achive this.

Ricardo.

This message has been edited. Last edited by: <Kathryn Henning>,

This might help...

  
-* File borgas01.fex
TABLE FILE CAR
SUM CAR
ACROSS CAR 
ON TABLE HOLD FORMAT DFIX DELIMITER ,
END
!TYPE HOLD.FTM

Very nice Daniel.

Thanks Daniel,

Thats exacly what i needed.
works perfectly.

Or create a comma delimited output file with format COM, COMMA, or COMT?