- Stop javaScript (Suppose Mozila) Paste about:config as a url or Ctrl + Shift + C.
- Toggle javaScript false.
- Search(If required) and copy table (id="resultTable") [outerHTML]
- Paste into Notepad++
- Remove unnecessary field and build table tag format. In Replace tab paste "Find what" box <((?!table|thead|tbody|th|tr|td|/table|/thead|/tbody|/th|/tr|/td)[^>]+)> and replace empty (search mode: regular expression). Not working ohh! don't be crazy! Use <((?!table|thead|tbody|th|tr|td|/table|/thead|/tbody|/th|/tr|/td)[^>]*)>.
- Set column field automic if required. In Replace tab paste "Find find what" box [Suppose text is 'Ministry of Water Resources, Bangladesh Water Development Board (BWDB),'] and replace empty (search mode: normal)
- Save as abc.html
- Open Excel file
- Click Data->Form Web ->New Web Query->Address box
- Paste http://localhost/abc.html
- Go
- Select table
- Import -> ok…
- Save as CSV file
- phpMyAdmin
- Import
- Table created
- Change date format
- Select all -> Format Cells
- Number->Category->Date->Custom->Type
- yyyy-mm-dd
- Ok
- Re name Database
- RENAME TABLE `table 3` TO `noa`;
- Set Column name and attributes
- Delete rows while ID is zero.
No comments:
Post a Comment