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...
Thank you, that works perfectly for the files I know the column breaks for.
For the files I don't know, which have different widths, is there a way to easily identify the number of characters other than manually counting them? The lack of a ruler/indicator makes the process quite time consuming.
For the files I don't know, which have different widths, is there a way to easily identify the number of characters other than manually counting them? The lack of a ruler/indicator makes the process quite time consuming.
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.
- Thanks @Sergei
- 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.
