Focal Point
[SOLVED] COMT output file producing line breaks

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1427099986

April 20, 2018, 02:55 PM
RaviD
[SOLVED] COMT output file producing line breaks
All,

I need to produce a CSV output, when I use the out type as COMT, it is introducing a line break after a alpha field, did anyone have any idea why it is intruding a line break? See below.

employee_id,first_name,last_name,email,supervisor_email,attempted_contacts_phone_week_0
002099999,Jennifer,xyz,jscha0001@domain.com,arifyyy@yyyyyy.com ,8

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


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
April 20, 2018, 02:59 PM
RaviD
actually the number 8 is coming in next line on above example instead of displaying in second line.


WebFocus 8202M
APP Studio
Info assist
Report caster
Portals
Maintain
EXcel,PDF,HTML,Active Reports
April 20, 2018, 03:02 PM
BabakNYC
I just tried this code and got all values in " separated with , and the output looks right.

 
APP HOLD TESTAPP
TABLE FILE CAR
SUM RETAIL DEALER SALES BY COUNTRY BY CAR BY MODEL
ON TABLE HOLD FORMAT COMT
END 


Can you share your code?


WebFOCUS 8206, Unix, Windows
April 25, 2018, 05:17 PM
Waz
Have you checked the data to see if there are ant CR's in it ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!