Jonathon Coombes wrote:
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
Yes, it looks at files and then guesses where the columns are
delimited.... For now, you would have to write a macro and then write it
once (at least until you changed the column widths). Unfortunately, that
requires an extra skill, writing a macro.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
