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/