greenmonster15
Board Regular
- Joined
- Aug 28, 2012
- Messages
- 70
I have webpage html source code save in a .txt file from IE.
I'm opening up the .txt in excel in order to extract the information I need.
Everything looks fine until I copy and paste the data into Word, or Notepad.
I get a bunch of quotation marks all over the place. An I opening up the .txt incorrectly somehow in Excel or do I need to write a script to remove all these buggers?
Sample from Excel:
<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>
Sample after pasted:
</p>
" <p align=""left""><span class=""body""></span></p>"
" </td>"
" </tr>"
" </table>"
" </div>"
" "
" <div align=""left"">"
<table border="0" cellpadding="0" cellspacing="0" width="450" class="body">
<tr><td class="Cat_Title">
</td></tr>
" "
" <tr>"
" <td valign=""top"">"
I'm opening up the .txt in excel in order to extract the information I need.
Everything looks fine until I copy and paste the data into Word, or Notepad.
I get a bunch of quotation marks all over the place. An I opening up the .txt incorrectly somehow in Excel or do I need to write a script to remove all these buggers?
Sample from Excel:
<p align="left"><span class="body"></span></p> |
</td> |
</tr> |
</table> |
</div> |
<div align="left"> |
<table border="0" cellpadding="0" cellspacing="0" width="450" class="body"> |
<tr><td class="Cat_Title"> |
</td></tr> |
<tr> |
<td valign="top"> |
<colgroup><col width="64" style="width: 48pt;"></colgroup><tbody>
</tbody>
Sample after pasted:
</p>
" <p align=""left""><span class=""body""></span></p>"
" </td>"
" </tr>"
" </table>"
" </div>"
" "
" <div align=""left"">"
<table border="0" cellpadding="0" cellspacing="0" width="450" class="body">
<tr><td class="Cat_Title">
</td></tr>
" "
" <tr>"
" <td valign=""top"">"