On Wed, 2005-01-19 at 22:24 -0500, Andrew Douglas Pitonyak wrote: > Jonathon Coombes wrote: > snip! > >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. > > > 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.
Yes, but some of the files I have gotten from clients are not "data" layed out nicely. They are reports and there are varying widths depending on which page you are up to :( If you have nice clean data, then yes, a macro would be a simply solution, otherwise, it is quite complicated. Regards Jonathon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
