Hello everyone,

I was hoping if anyone here can help with an issue I am having. I've created a report that saves an output as a txt. with a delimiter | but when I open it the column headers on top do not display. I was wondering if there is a line of code that is needed so that they do display properly? I will include the code for the fex. and for the txt. output. Any help would be appreciated. Thank you!

  
-SET &ECHO = ALL;
-SET EMPTYREPORT = ON;

DEFINE FILE PE_FFJITMBP
-*Manufacturer/A100=PE_FFJITMBP.PE_FFVVNDAP.FFVVNMV |' - '| PE_FFJITMBP.PE_FFJITMBP.FFJVNDN;
PBHF/A50=PE_FFJITMBP.PE_EAAPBHFP.EAAFNME | ' _ '| PE_FFJITMBP.PE_FFJITMBP.FFJPBHF;
MinFacingsX/I2=1;
TRIMDIR3/A17=TRIM_(BOTH, ' ',  PE_FFJITMBP.PE_FFJITMBP.FFJVNDN);
PBG3/A50=PE_FFJITMBP.PE_FFVVNDAP.FFVVNMV | ' -('| TRIMDIR3 |')';
SQUEEZZ3/A50=TRIMV('T', SQUEEZ(50, PBG3, 'A50'), 50, ' ', 1, SQUEEZZ3);
TRIMDIR/A17=TRIM_(BOTH, ' ', PE_FFJITMBP.PE_EEBPBHAP.EEBPBHN);
PBG/A50=PE_FFJITMBP.PE_EEBPBHAP.EEBPNME | ' -('| TRIMDIR |')';
SQUEEZZ/A50=TRIMV('T', SQUEEZ(50, PBG, 'A50'), 50, ' ', 1, SQUEEZZ);
TRIMDIR2/A17=TRIM_(BOTH, ' ',  PE_FFJITMBP.PE_FFJITMBP.FFJPBHF);
PBG2/A50=PE_FFJITMBP.PE_EAAPBHFP.EAAFNME | ' -('| TRIMDIR2 |')';
SQUEEZZ2/A50=TRIMV('T', SQUEEZ(50, PBG2, 'A50'), 50, ' ', 1, SQUEEZZ2);
CLS/A50=PE_FFJITMBP.PE_FFBCLSAP.FFBCLSN | ' - ' | PE_FFJITMBP.PE_FFBCLSAP.FFBSDSC;
UPCLIP/A100=PE_FFJITMBP.PE_FFIITMAP.FFIUPCP || PE_FFJITMBP.PE_FFIITMAP.FFIITMN;
UOM/A10='NULL';
DistributionType/A50='W';
Status/A20='Active';
Color/A20='NULL';
IsActive/A10='TRUE';
MinDOS/I2=1;
MaxDos/I2=0;
MaxFacingsY/I2=0;
MaxFacingsZ/D2=0;
MaxLayoversY/I2=0;

ORGANIC/A10      = IF FITORGN EQ 'Y' THEN 'ORGANIC'     ELSE '';
KOSHER/A10       = IF FITKOSH EQ 'Y' THEN 'KOSHER'      ELSE '';
ALL_NAT/A10      = IF FITANIF EQ 'Y' THEN 'ALLNATURAL'  ELSE '';
GLUTEN_FREE/A10  = IF FITGLFR EQ 'Y' THEN 'GLUTENFREE'  ELSE '';
FAT_FREE/A10     = IF FITNOFT EQ 'Y' THEN 'FATFREE'     ELSE '';
SUGAR_FREE/A10   = IF FITSGFR EQ 'Y' THEN 'SUGARFREE'   ELSE '';
PEANUTS/A10      = IF FITNUTP EQ 'Y' THEN 'PEANUTS'     ELSE '';
FARM_RAISED/A10  = IF FITFRMF EQ 'Y' THEN 'FARMRAISED'  ELSE '';
NON_GMO/A10      = IF FITGMO  EQ 'Y' THEN 'NON-GMO'     ELSE '';
LACTOSE/A20      = IF FITLAFR EQ 'Y' THEN 'LACTOSEFREE' ELSE '';

WIDTH_1/D7.2 =  IF FITWDTR EQ 0 THEN 4 ELSE FITWDTR;
HEIGHT_1/D7.2 = IF FITHGTR EQ 0 THEN 4 ELSE FITHGTR;
DEPTH_1/D7.2  = IF FITDPTR EQ 0 THEN 4 ELSE FITDPTR;

ITMN_SET/A30  = IF FFIUPCP EQ '' THEN FFJITMN ELSE FFIUPCP;

END
TABLE FILE PE_FFJITMBP
-*     PE_FFJITMBP.PE_FITMEXTP.FITKOSH
-*     PE_FFJITMBP.PE_FITMEXTP.FITANIF AS 'AllNatural'
-*     PE_FFJITMBP.PE_FITMEXTP.FITGLFR AS 'GlutenFree'
-*     PE_FFJITMBP.PE_FITMEXTP.FITNOFT AS 'FatFree'
-*     PE_FFJITMBP.PE_FITMEXTP.FITSGFR AS 'SugarFree'
-*     PE_FFJITMBP.PE_FITMEXTP.FITNUTP AS 'ContainsPeanut'
-*     PE_FFJITMBP.PE_FITMEXTP.FITFRMF AS 'FarmRaised'
-*     PE_FFJITMBP.PE_FITMEXTP.FITGMO AS 'NonGMO'
-*     PE_FFJITMBP.PE_FITMEXTP.FITLAFR AS 'LactoseFree'
PRINT
     IsActive
     MinDOS
     MaxDos
     MinFacingsX
     MaxFacingsY
     MaxFacingsZ
     MaxLayoversY
     PE_FFJITMBP.PE_FFBCLSAP.CLS AS 'L1'
     PE_FFJITMBP.PE_EEBPBHAP.SQUEEZZ AS 'L2'
     PE_FFJITMBP.PE_EAAPBHFP.SQUEEZZ2 AS 'L3'
     PE_FFJITMBP.PE_FFJITMBP.FFJZUA1 AS 'ItemType'
     PE_FFJITMBP.PE_FITMEXTP.ORGANIC AS 'Organic'
     PE_FFJITMBP.PE_FITMEXTP.KOSHER AS 'Kosher'
     PE_FFJITMBP.PE_FITMEXTP.ALL_NAT AS 'AllNatural'
     PE_FFJITMBP.PE_FITMEXTP.GLUTEN_FREE AS 'GlutenFree'
     PE_FFJITMBP.PE_FITMEXTP.FAT_FREE AS 'FatFree'
     PE_FFJITMBP.PE_FITMEXTP.SUGAR_FREE AS 'SugarFree'
     PE_FFJITMBP.PE_FITMEXTP.PEANUTS AS 'ContainsPeanut'
     PE_FFJITMBP.PE_FITMEXTP.FARM_RAISED AS 'FarmRaised'
     PE_FFJITMBP.PE_FITMEXTP.NON_GMO AS 'NonGMO'
     PE_FFJITMBP.PE_FITMEXTP.LACTOSE AS 'LactoseFree'
BY  PE_FFJITMBP.PE_FFJITMBP.FFJITMN AS 'SKU'
BY  PE_FFJITMBP.PE_FFIITMAP.ITMN_SET AS 'UPC'
BY  PE_FFJITMBP.PE_FITMEXTP.FITZABX AS 'NAME'
BY  PE_FFJITMBP.PE_FGJBRNDP.FGJBRDN AS 'Brand'
BY  PE_FFJITMBP.PE_FFVVNDAP.SQUEEZZ3 AS 'Manufacturer'
BY  DistributionType
BY  Status
BY  PE_FFJITMBP.PE_FITMEXTP.HEIGHT_1 AS 'Height'
BY  PE_FFJITMBP.PE_FITMEXTP.WIDTH_1 AS 'Width'
BY  PE_FFJITMBP.PE_FITMEXTP.DEPTH_1 AS 'Depth'
BY  PE_FFJITMBP.PE_FFIITMAP.FFIPCKI AS 'Pack'
WHERE ( PE_FFJITMBP.PE_FFJITMBP.FFJCMPN EQ '  1' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJDIVN EQ '  1' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJDPTN EQ '  1' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJWHSN EQ '  1' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJARCD EQ 'A' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJZUA1 NE 'C' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJITMN GE '    000103' ) AND ( PE_FFJITMBP.PE_FFJITMBP.FFJITMN LE '    999999' );
WHERE FFJZUA1 NE 'C';
WHERE (FFJITMN GE '    000103') AND (FFJITMN LE '    999999');
-*WHERE RECORDLIMIT EQ 1000
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT AHTML
-*-*SAVE TO E: BY UNCOMMENTING LINE BELOW AND COMMENTING ON TABLE PCHOLD ABOVE-*-*
ON TABLE SAVE FILENAME
'E:\ibi\i2e.txt'
FORMAT DFIX DELIMITER |
-*-*-*-*-*-*-*-*-*

I'll also post a few lines from the txt. output:

000103|075192001036|ROTELLA BAKERY BREAD VIENNA SLICED 18.59OZ|ROTELLA BAKERY|ROTELLA'S ITALIAN BAKERY -(1118 )|W|Active|2.95|5.65|13.60|6|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
000121|075192001210|ROTELLA BAKERY BREAD ITALIAN SANDWICH SLICED 18.59OZ|ROTELLA BAKERY|ROTELLA'S ITALIAN BAKERY -(1118 )|W|Active|3.50|5.20|11.95|8|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
000310|075192003108|ROTELLA BAKERY ROLL SPLIT TOP HOAGIE SLICED 18.60|ROTELLA BAKERY|ROTELLA'S ITALIAN BAKERY -(1118 )|W|Active|4.00|4.00|4.00|6|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
000401|074865881593|ROTELLA BAKERY BUN EGG KAISER SLICED 21.28OZ|ROTELLA BAKERY|ROTELLA'S ITALIAN BAKERY -(1118 )|W|Active|4.00|4.00|4.00|6|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
000681|075192006819|ROTELLA BAKERY BUNS BRAT 6PK 14.58OZ|ROTELLA BAKERY|ROTELLA'S ITALIAN BAKERY -(1118 )|W|Active|4.35|8.50|6.55|9|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
003500|737734002016|WNA COMET TRAY RECTANGLE BLACK #A1812BL 18X12|WNA COMET|WADDINGTON NORTH AMERICA -(1385 )|W|Active|4.00|4.00|4.00|20|TRUE|1|0|1|0|0|0|130 - PACKAGING|SPECIAL ITEMS - PACKAGING -(3990 )|SPECIAL ITEMS - PACKAGING -(39960 )|S| | | | | | | | | |
003741|037407046508|RW BAKERS BREAD FULLY BAKED FRENCH 16OZ|RW BAKERS|LAVOI CORP/RW BAKERS -(4110 )|W|Active|4.00|4.00|4.00|14|TRUE|1|0|1|0|0|0|120 - BAKERY|BREADS - BKY -(2010 )|BREADS/ROLLS-FOODSERVICE -(20140 )|R| | | | | | | | | |
004900|737734001873|WNA COMET LID RECTANGLE TRAY #A1812DM 18X12|WNA COMET|WADDINGTON NORTH AMERICA -(1385 )|W|Active|4.00|4.00|4.00|40|TRUE|1|0|1|0|0|0|130 - PACKAGING|SPECIAL ITEMS - PACKAGING -(3990 )|SPECIAL ITEMS - PACKAGING -(39960 )|S| | | | | | | | | |
005100|074729910100|DURABLE PAN ALUM CAKE-HOLIDAY W/LIDS 8"DIA|DURABLE|DURABLE INC. -(1790 )|W|Active|4.00|4.00|4.00|100|TRUE|1|0|1|0|0|0|130 - PACKAGING|HOLIDAY - PACKAGING -(7030 )|HOLIDAY BOOK-PACKAGING -(90240 )|H| | | | | | | | | |
005200|074729940107|DURABLE PAN ALUM LOAF W/LID-HOLIDAY 2#|DURABLE|DURABLE INC. -(1790 )|W|Active|4.00|4.00|4.00|100|TRUE|1|0|1|0|0|0|130 - PACKAGING|HOLIDAY - PACKAGING -(7030 )|HOLIDAY BOOK-PACKAGING -(90240 )|H| | | | | | | | | |

This message has been edited. Last edited by: FP Mod Chuck,

Add HEADER YES to the ON TABLE SAVE syntax. Something like this:

ON TABLE SAVE AS filename FORMAT DFIX DELIMITER | HEADER YES

Thank you BabakNYC!

This is exactly the line of code I was looking for!