If this is a one-off type of job*, sometimes the simplest thing to do is capture the screen output as a .txt file, then import to excel as fixed length fields. Quick and dirty? Yes, but his would work pretty well for your detail-suppress requirement. I use BREAK-ON fieldname "'L'" to remove the extra blank lines between rows.
*Actually, I have used this for regular, repeating jobs, by scripting accuterm to capture the screen output as a specific filename in a specific directory, then printing instructions on the screen telling the user how to import into excel. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 /Scott Ballinger On Feb 12, 2008 4:32 PM, IT-Laure Hansen <[EMAIL PROTECTED]> wrote: > Hi Louie, > > You are correct, it does - however I am dealing among others with a set > of files that contain about 85000 individual records: too much for Excel > in the first place, and also, updating the MITS data source takes simply > too much time, especially when adding break/sort fields. A simple > Universe report using DET-SUP takes a couple of minutes to run. The > equivalent using MITS Reports with a data source update to grab the > latest data literally takes hours. So, I am looking for a solution that > allows me to do the equivalent of a LIST DET-SUP in Universe, and > convert the output into true Excel. > > Thanks, > > Laure Hansen, > City of Redwood City > Information Technology > 1017 Middlefield Road > Redwood City, CA 94063 > Tel 650-780-7087 > Cell 650-207-3235 > Fax 650-556-9204 > [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
