hello
I would like to know how to merge Excel lines with newlines if it is the same key.
Thank for all.

DEFINE FILE RESERV
LG_4CMD/A800 = IF ITEM2 EQ LAST THEN SUBSTR(800, LG_4CMD, 1, 400, 400, 'A400') || CHAMP ELSE CHAMP || '
';
END

TABLE FILE RESERV
LG_4CMD AS 'Liste des Cmdes magasin'
ON TABLE HOLD AS TAB_FINA FORMAT HTMTABLE
END

SET HTMLFORMTYPE=XLS
-*-SET HTM
-RUN
-HTMLFORM BEGIN

!IBI.FIL.TAB_FINA;

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

I see a couple of issues with your code:

1. Your DEFINE syntax is not quite correct.
2. You are missing a verb (PRINT, SUM) in your TABLE request.
3. Using a DEFINE assumes the data is already sorted in proper order; if not, you should sort the data in your TABLE request and use a COMPUTE instead of a DEFINE.
4. Using a variable length field (A800V) with hard concatenation (||) is simpler and safer than using function SUBSTR, unless you use function ARGLEN in conjunction with SUBSTR.

Your code should probably look more like this:

TABLE FILE RESERV
 PRINT
 COMPUTE LG_4CMD/A800V = IF ITEM2 EQ LAST ITEM2 THEN (LG_4CMD || (' ' | CHAMP)) ELSE CHAMP ; AS 'Liste des Cmdes magasin'
 BY ITEM2 NOPRINT
 BY CHAMP NOPRINT
 ON TABLE HOLD AS TAB_FINA FORMAT HTMTABLE
END
.
.
.

Are you looking for something like this?

TABLE FILE CAR
BY COUNTRY
BY CAR
ON TABLE HOLD
END

DEFINE FILE HOLD
CAR_CON/A400V=IF COUNTRY EQ LAST COUNTRY THEN (CAR_C|| (' ' | CAR))  ELSE CAR;
END
TABLE FILE HOLD
SUM
LST.CAR_CON AS 'Car Concatenated'
BY COUNTRY  AS 'Country'
END

I think this may be helpful:

DEFINE FILE CAR
CR/A1=HEXBYT(10,CR);
TESTSTR/A200V = IF COUNTRY EQ LAST COUNTRY THEN
                TESTSTR || CR || CAR ELSE CAR;
END
TABLE FILE CAR
PRINT TESTSTR
ON TABLE PCHOLD FORMAT EXL2K
END

Hope this helps ...

Hello,
Yes it works is fantastic,
thank you for all.