Focal Point
[CLOSED]-Extra blank line in TABT format

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

December 29, 2016, 06:33 AM
Neelima
[CLOSED]-Extra blank line in TABT format
Hi All,

I am getting extra line in last when I open the TABT file in notepad.When I am opening the file in Excel, it is not coming.

I am not understanding why it is showing in notepad.

I appreciate the response.

Thanks

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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
December 29, 2016, 11:00 AM
Prarie
Try TAB instead.
December 30, 2016, 01:43 AM
Neelima
Yes, I have tried with TAB format also.. Still, it is coming.. below are code for same.

-SET &ECHO=ALL;
-SET &CRLFHEADER = HEXBYT(13, 'A1');
DEFINE FILE CAR
CRLF/A2 = HEXBYT(13,'A1');
DATAA/A200=MODEL||COUNTRY;
END

TABLE FILE CAR
PRINT
DATAA
CAR
CRLF AS '&CRLFHEADER'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT TAB
END

Thanks


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
December 30, 2016, 08:54 AM
jgelona
I'm not sure why you think you have a problem.

Each row in your file will end with a CRLF or just a LF if you are on a Unix/Linux server.

In Notepad, you don't have a blank line, you have an empty line. The cursor is positioned on the next available line.

Excel is recognizing this so it is dropping the empty line.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
December 30, 2016, 01:26 PM
Neelima
I agreed Jgelona.. I am asking If is there any remediation for same.

Thanks for you response.

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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
January 02, 2017, 05:14 AM
Wep5622
Why do you think you need a remedy?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
January 03, 2017, 03:26 AM
Neelima
Actually, client don't want to see this extra line. Even we have informed them that In TABT format, Each record end up with a carriage return and Line Feed.

they convinced but asked for some alternative.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
January 03, 2017, 06:13 AM
Neelima
I am closing this thread..

Thanks for everyone.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies