On Wed, 2005-01-19 at 10:23 -0500, G. Roderick Singleton wrote: > On Wed, 2005-01-19 at 06:12 -0600, Kent Tenney wrote: > > That's it Jonathan. > > > > Fixed field length is evidently used very rarely, hence not > > not a lot of effort in supporting it. > > > > Each row of the import file is 884 characters, comprising 82 columns. > > Bringing it into Calc consists of setting each of the 82 column > > dividers manually. > > > > > > Oh I see you want OOo to intuitively to know and understand the > divisions when opening your file. I do not see how any program can do > that as you must know and understand the table layout from which the > fixed fields come. When you open your file in Calc as fixed field you > must set the proper boundaries manually each time or get the source > database to delimit the fixed fields. >
That would be nice, but not necessarily impossible. Microsoft Excel for example does a text-to-columns feature when importing these types of files and although not perfect, can be adjusted quickly to the right effect. I understand that currently we have to set the fixed width details when importing, its just a hassle when you are doing it to multiple reports continuously during the day. An off the top of my head example of enhancment - with the fixed-width option, allow the user to load an xml file detailing the column widths or breakdown in some way. This means that you do it once, and then simply load the two files together when you import it next time. Regards Jonathon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
