<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.2.2">
</HEAD>
<BODY>
Hi,<BR>
<BR>
On ABCD (Linux) I created a display format using the option which makes provision for the generation of a delimited (|) file for importing into a spreadsheet, e.g. Excel, OpenOffice, etc.<BR>
I then 'printed' records from the database and saved it as a .txt file. However, when importing this file into for example Excel, some lines/records are ok, in some cells go over into the next line. <BR>
I then changed the display format to a very basic format, and generated the file with mx on the command line, but still there are line breaks in between.<BR>
Here is the display format:<BR>
<BR>
mfn(5),'|',v996^c,| |v996^a,| |v996^b,'|',v200^a*0.100,'|',v700^a,|, |v700^b,'|',v913,'|',v914,'|',#<BR>
<BR>
Generated file:<BR>
003438| 820 GOR|Life Times|Gordimer, Nadine|2012/0197|00003438|<BR>
003439| 820 ACH|No longer at Ease|Achebe, Chinua|2012/0198|00003439|<BR>
003440| 920.2 ROB|No cold Kitchen|Roberts, Ronald|2012/0199|00003440|<BR>
003441| 896.68 COE|African Pens 2011|Coetzee, J.M.|2012/0200|00003441|<BR>
<B>003442|NAM 831 KAP|Poetry: Literature the big Picture|Kaputu, U.R. Princley|</B><BR>
<B>2012/0201|00003442|</B><BR>
<B>003443|NAM 820 LOET|Oral Tradition Stories told in Namibia|Loetter, Rene|</B><BR>
<B>2012/0203|00003443|</B><BR>
<B>003444| J 5 LOET|Oral Tradition Stories told in Namibia|Loetter, Rene|</B><BR>
<B>2012/0202||</B><BR>
<B>003445| J 3 AMU|Mrs. Kangaroo visits Namibia|Amutenja, Ambrosius N.|2012/0204|</B><BR>
<B>00003445|</B><BR>
<BR>
The lines in bold have a break which prevents the correct import into the spreadsheet.<BR>
<BR>
Please advise how to solve the problem.<BR>
Thanks<BR>
Renate<BR>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<BR>
Renate Morgenstern<BR>
Tel.: +264 61 242124<BR>
Cell: +264 81 2910284<BR>
Fax: 088637518<BR>
Windhoek, Namibia
</TD>
</TR>
</TABLE>
</BODY>
</HTML>