[Isis-users] Comma delimited file generation

[Renate Morgenstern]

Thanks for the help.
How can I specify the line length when generating the list in ABCD?
I could not do it there, so I used cisis.
Regards
Renate


> Renate
> 
> by default the print line is 80 chars length, so if your line is
> longer, mx will insert a <cr> every 80 chars
> to overide it you should use the parameter   lw=   (line width)  with
> any value up to 8000 chars
> 
> so your command should be   
> 
> mx  mybase pft=@something.pft  lw=8000   etc
> 
> regards
> Ernesto Spinak
> 
> 
> 
> El 09/09/2015 a las 15:57, Renate Morgenstern escribió:
> 
> > 
> > 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 
> > 
> > 
> > 
> > _______________________________________________
> > isis-users mailing list
> > isis-users at iccisis.org
> > To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
> > Or contact Henk Rutten: hlrutten at xs4all.nl
> 
> 
> 
> 
> -- 
>   .^.                                .^.
>   ( )                                ( )
>   ===                                ===
>  =[=]================================[=]=
>   | |  Ernesto Spinak                | |
>   | |  spinaker at adinet.com.uy        | |
>   | |  Montevideo, Uruguay           | |
>   | |  tel/fax  (598) 2622-3352      | |
>   | |  celular  (598) 99612238      | |
>  =[=]================================[=]=
>   ===                                ===
>   ( )                                ( )
>    V                                  V 
> _______________________________________________
> isis-users mailing list
> isis-users at iccisis.org
> To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
> Or contact Henk Rutten: hlrutten at xs4all.nl


-- 

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/02414d5b/attachment.html>