As part of one task in a CMS development, may this blog serve as my personal notepad for future referencing :D
1. Needed to import the list of countries found in the country dropdown list in this online database.
2. Problem: How to import the list items (also viewable in View Source and can be tediously weeded out in any text editor) into tabular data,for example in MS Excel?
3. While on the targeted webpage with the needed content, save page as type txt, Encoded as Unicode (UTF-8).
4. Open MS Excel, File > Open > go to saved text unicoded file, then follow the wizard and series of steps in how to display the data in Excel, this time in tabular format.
-End-
No comments:
Post a Comment