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,

Try TAB instead.

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

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.

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,

Why do you think you need a remedy?

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.

I am closing this thread..

Thanks for everyone.