First off, what are you planning to do with the data once you have it in Excel? In most cases it won't be useful unless you explode/flatten the data out. We have a few (UniData) solutions for turning LIST/SORT/CT output into symbolic link/html(with or without table view)/csv files, and use SBClient to handle passing the file to the client PC and opening the correct application.

David Beahm


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

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.



u2-users mailing list

Reply via email to