Add COUNT.SUP, COL.SUP, HDR.SUP to suppress record count at the bottom, column headers and report header. note that if longer than 32K lines there will be a char(12) (page break) inserted. Excel does not handle that as a page break.
Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell: 650-207-3235 ________________________________ From: [email protected] <[email protected]> To: 'U2 Users List' <[email protected]> Sent: Fri Jun 12 06:40:53 2009 Subject: Re: [U2] Send output from query to text file Exactly! But also set the page length to something huge (999999) so that you only have 1 header. Scrape the first couple of lines (if needed) and the reset is raw text. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Schasny Sent: Friday, June 12, 2009 9:39 AM To: U2 Users List Subject: Re: [U2] Send output from query to text file Thats what the &HOLD& file is for. Use the SETPTR command to redirect printing to the hold file by using mode 3 in the 6th parameter of your SETPTR statement and append LPTR to your query: >SETPTR 0,132,66,0,0,3,BANNER FILENAME.TXT,NHEAD,NFMT,BRIEF >LIST VOC SAMPLE 10 LPTR This will put the output of LIST VOC SAMPLE 10 into a file in &HOLD& called FILENAME.TXT Norman Bauer wrote: A lot of the times I want to query UniVerse and capture that information to a text file. I can send to an XML file no problem and sometimes that is exactly what I want to do. However most of the time I just want to view the info unformatted without screen scraping or copy and pasting from Dynamic Connect. What I really want to do is: SORT VOC \\server\fileshare\file.txt Thanks, Norm ________________________________ _______________________________________________ U2-Users mailing list [email protected]<mailto:[email protected]> http://listserver.u2ug.org/mailman/listinfo/u2-users -- ________________________________ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ________________________________
_______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
