[Isis-users] Comma delimited file generation

[spinaker]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20150909/afa47709/attachment.html>