[Isis-users] Comma delimited file generation

Renate Morgenstern rmorgenstern at iway.na
Wed Sep 9 20:57:53 CEST 2015


Hi,

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.
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. 
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.
Here is the display format:

mfn(5),'|',v996^c,| |v996^a,| |v996^b,'|',v200^a*0.100,'|',v700^a,|, |
v700^b,'|',v913,'|',v914,'|',#

Generated file:
003438| 820 GOR|Life Times|Gordimer, Nadine|2012/0197|00003438|
003439| 820 ACH|No longer at Ease|Achebe, Chinua|2012/0198|00003439|
003440| 920.2 ROB|No cold Kitchen|Roberts, Ronald|2012/0199|00003440|
003441| 896.68 COE|African Pens 2011|Coetzee, J.M.|2012/0200|00003441|
003442|NAM 831 KAP|Poetry: Literature the big Picture|Kaputu, U.R.
Princley|
2012/0201|00003442|
003443|NAM 820 LOET|Oral Tradition Stories told in Namibia|Loetter,
Rene|
2012/0203|00003443|
003444| J 5 LOET|Oral Tradition Stories told in Namibia|Loetter, Rene|
2012/0202||
003445| J 3 AMU|Mrs. Kangaroo visits Namibia|Amutenja, Ambrosius N.|
2012/0204|
00003445|

The lines in bold have a break which prevents the correct import into
the spreadsheet.

Please advise how to solve the problem.
Thanks
Renate


-- 

Renate Morgenstern
Tel.: +264 61 242124
Cell: +264 81 2910284
Fax: 088637518
Windhoek, Namibia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20150909/5dd492f0/attachment.html>


More information about the isis-users mailing list