Re: [U2] Send output from query to text file

[Bill Haskett]

Ed: You mention "FWIW, DELIM only seems to be recognised with ECLTYPE U."  Then change the command to (note the lower case verb): :sort VOC NI-SUPP COL-HDR-SUPP HDR-SUPP ATB1 ATB2 ATB3 TO DELIM "|" \\server\fileshare\file.txt The lower case verb parses the sentence in UniData mode if you're already in ECLTYPE P.  HTH, Bill From: Edward Brown <ebr...@civica.co.uk> Sent: 6/12/2009 6:47 AM To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Send output from query to text file Didn’t know about this method, but I can see it being very useful in the future – the option to set the delimiter could be extremely useful – as it puts all the output data into an easily parsed / loadable into Excel format.   FWIW, DELIM only seems to be recognised with ECLTYPE U.   Ed   From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: 12 June 2009 14:27 To: U2 Users List Subject: Re: [U2] Send output from query to text file   I can't speak for UV, but in UD you could do something like      SORT VOC ATB1 ATB2 ATB3 TO DELIM "|" \\server\fileshare\file.txt This would create a pipe-delimited txt file. Brad. u2-users-boun...@listserver.u2ug.org wrote on 06/12/2009 08:22:17 AM: > [image removed] > > [U2] Send output from query to text file > > Norman Bauer > > What I really want to do is: > > SORT VOC \\server\fileshare\file.txt > U.S. BANCORP made the following annotations --------------------------------------------------------------------- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. --------------------------------------------------------------------- ------------------------------------------------------------------------------------------- Please remember to recycle wherever possible.  Reduce, reuse, recycle, think do you need to print this e-mail? ------------------------------------------------------------------------------------------- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring.   Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. -------------------------------------------------------------------------------------------   _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users