Jim; As you may have noticed from the replies: there are a number of ways to do this. Depending on the number of files/fields and the frequency you want to do this, and any connection options you currently have will affect your final choice.
You may want something powerful like a data transformation tool (eg. zeus, mvquery, etc). You could setup an ODBC/oleDB/UniObjects links. Custom programs to create normalized (or not) text delimited or fixed length file(s) - these could even be in excel format. Something like the download utility from ftp.cedarville.edu. The later versions of UniData (I'm not sure about UniVerse) have some extensions to the list statement to put the output to an OS file using the TO and TOXML keywords. Some things to consider: Excel won't "choke" on the VM's etc they are ascii characters in the 250 range. It will however treat them as a text character and not as any type of delimiter. When converting to fixed length do you want to truncate fields or make sure they are at least as large as the largest data value? hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 14, 2004 8:34 AM >To: [EMAIL PROTECTED] >Subject: UV to Text Conversion Standard? > > >I am hopeful someone can offer me some guidance. > >I have to move data off of my Universe system and send it to a PC for >inclusion in a Excel Spreadsheet. > >Some background: >Source data is alpha/ numeric and contains VM's, SVMs and TM >Source data fields are variable lengths > >Requirements: >Output must be fixed length >Output must be importable into Excel (column definitions will >be based on a >fixed length map) > >My problem: >I think Excel will choke on VMs, SVMs and TM characters. Is there a >standard , ASCII character that I should use to represent >them? To further >complicate things, sone of the fields represent data that was >input with >little (or no restrictions), ie. any character on the keyboard was >considered valid. > >Thanks > >Jim > > >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
