RE: [U2] [UD] Tab characters in output
I have found the tab character to be extremely effective in delineating columns of information. The simple command: SWAP CHAR(9) WITH @VM IN report-table Instantly changes the report to a usable table in UniBasic. Using any 'printing' character (like the pipe '|' or caret '^') is unreliable as to guaranteeing clean column/value marks. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Tab characters in output
For what it's worth, the UniBasic LISTUSER() function provides dynamic array of the detail items. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support Mark your calendar! From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: 09/12/2008 08:30 AM Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Anyplace you have to parse output is confounding!! I think most of this is in system() variables - but there are some things that don't seem to be... Listuser is also an .exe in the \bin directory. Have you tried parsing that output? It may be more advantageous if you're close to your user count. There is GETREADU(), it would be nice if there was a GETLISTU() as well. While I'm at it, it would also be nice to dump list/sort output into an array. Hth Colin Alfke Calgary, Canada -Original Message- Bill Haskett Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Tab characters in output
When I need to build an export file, I always build each row as a FM delimited array. This allows me to take advantage of all the basic commands. When I am ready to write the row to disk (via WRITESEQ), I always run a common piece of code to: Convert all tabs to spaces Convert all vms to spaces Convert all sms to spaces Trim the array Convert all fms to tabs Write to disk The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. Of course, each program might have exceptions. If you have questionable data, you could also us the OCONV code to remove these prior to writing the row to disk. John -- Sent using BlackBerry - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Fri Sep 12 10:10:56 2008 Subject: RE: [U2] [UD] Tab characters in output I have found the tab character to be extremely effective in delineating columns of information. The simple command: SWAP CHAR(9) WITH @VM IN report-table Instantly changes the report to a usable table in UniBasic. Using any 'printing' character (like the pipe '|' or caret '^') is unreliable as to guaranteeing clean column/value marks. David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
If the command is like the one in UV then it actually comes from the operating system (who), at least in the Unix world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 8:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Colin: !listuser returns tabs too. Oh well. While I'm at it, it would also be nice to dump list/sort output into an array. Sounds like a BB entry (if only I could figure out how). :-) Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Friday, September 12, 2008 8:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Tab characters in output Anyplace you have to parse output is confounding!! I think most of this is in system() variables - but there are some things that don't seem to be... Listuser is also an .exe in the \bin directory. Have you tried parsing that output? It may be more advantageous if you're close to your user count. There is GETREADU(), it would be nice if there was a GETLISTU() as well. While I'm at it, it would also be nice to dump list/sort output into an array. Hth Colin Alfke Calgary, Canada -Original Message- Bill Haskett Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Thanks Wally. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Friday, September 12, 2008 7:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Tab characters in output For what it's worth, the UniBasic LISTUSER() function provides dynamic array of the detail items. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support Mark your calendar! From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: 09/12/2008 08:30 AM Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Instead of complaining we should send them a thank-you note. Sent from my Windows Mobile. phone. -Original Message- From: Bill Haskett [EMAIL PROTECTED] Sent: Friday, September 12, 2008 7:21 AM To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
While I'm at it, it would also be nice to dump list/sort output into an array. Not exactly what you're asking for, but you may get some help from the TO DELIM UniQuery keywords to create flat, delimited files that can be read in by your program or by Excel and other applications. I use it all the time and it works great. It's one of those features that's been out there almost forever ,but most folks aren't quite aware of its usefulness. Make sure you read up on UDT.OPTIONS 91 before playing around with it. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Thanks. Actually, I do use this one. In fact, I have an enhancement request in that it put CRLF after each line instead of just LF on Windows systems. UDT.OPTIONS 91 always seemed backwards to me. If you're using the LIST syntax you would expect things in converted form - not the other way around. It's easy enough to create dicts (or even list statements) without conv codes. Colin Alfke Calgary, Canada -Original Message- Timothy Snyder While I'm at it, it would also be nice to dump list/sort output into an array. Not exactly what you're asking for, but you may get some help from the TO DELIM UniQuery keywords to create flat, delimited files that can be read in by your program or by Excel and other applications. I use it all the time and it works great. It's one of those features that's been out there almost forever ,but most folks aren't quite aware of its usefulness. Make sure you read up on UDT.OPTIONS 91 before playing around with it. Tim Snyder --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
I guess you haven't used Excel 2007. It gives you an error message - although it does still give you the option to open the file. Hth Colin Alfke Calgary, Canada -Original Message- Israel, John R. [snip] The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
UDT.OPTIONS 91 always seemed backwards to me. If you're using the LIST syntax you would expect things in converted form - not the other way around. It's easy enough to create dicts (or even list statements) without conv codes. I agree that it seems backwards. My guess is that, when TO DELIM was implemented, it output it as raw, which is pretty much useless for most implementations. So formatted output was added. But, rather than change the default behavior (and possibly screwing up anybody that had built anything around the old behavior), UDT.OPTIONS 91 was added. As we all know, changing behavior (even bad behavior) often causes more problems that it solves - not to mention much wailing and gnashing of teeth. ;-) Like I said, I'm just guessing. But if you look at a lot of the UDT.OPTIONS, they seem backwards; I suspect it's all for the same reason. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
Colin, is this the error you're referring to? The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? (Yes | No | Help) If so, information is available here: http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extensio n-Warning.aspx Thanks to Ross Morrissey who provided that link in a Support request. NebulaXLite generates Excel documents as XML files, and Office 2007 users get prompted when opening the docs if the docs are saved and deployed with a .xls extension. The information on that page helps to eliminate the problem. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/products/xlite.htm From: Colin Alfke I guess you haven't used Excel 2007. It gives you an error message - although it does still give you the option to open the file. From Israel, John R.: The other thing I usually do is save the export with a .xls extension. The causes it to automatically fire up in Excel. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/