Forum Discussion
Import text file
Hi all, My Office 365 has recently updated with the new wizard for importing data. I work with a number of text files which I import into excel using the Text Import Wizard. I would insert Fixed wid...
Ross, if you have some logic of how to split (e.g. based on width of the first three words in the column before the space, whatever) i guess it'll be possible to formalize it and automate. Query itself knows nothing about that logic, you have to define it somehow.
Depends on how complex is the logic, perhaps it could be possible to define query steps just from user interface; or some coding will be required.
A way to replicate the legacy wizard is to import the text file using the new wizard and formatting it to just one column, then use the Text to Columns feature to insert column breaks using mouse clicks.
Hi Ross,
Yes, Text to Column actually uses the same engine as legacy wizard, just another entry into the it.