Removing HTML from excel column

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

ausgrl
Posts: 2
Joined: Thu Oct 01, 2009 4:45 am

Removing HTML from excel column

Postby ausgrl » Thu Oct 01, 2009 4:56 am

Hello -

Can you tell me if this is the correct product to perform the following (and possibly a hint how).

I have an Excel spreadsheet with one column containing html mark-up within the text.

I need to :
-retain the row/column structure
-remove ALL information contained within any <table></table> tags
-remove remaining HTML tags so I am left with plain text

I tried running the TextPipe with the HTML removal filter, but then the worksheet wouldn't open in excel (data corrupt).

Thanks!

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Removing HTML from excel column

Postby DataMystic Support » Thu Oct 01, 2009 8:42 am

Of course TextPipe works with text files, not with Excel files.

However, if you highlight the desired column in Excel, copy it to the clipboard, then switch to TextPipe and apply the remove HTML filter on the Clipboard (see the Trial Run, Go, Clipboard buttons at the bottom of the screen),
then you can paste the result back into Excel and the rows should remain inplace.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

ausgrl
Posts: 2
Joined: Thu Oct 01, 2009 4:45 am

Re: Removing HTML from excel column

Postby ausgrl » Thu Oct 01, 2009 2:30 pm

Doh - blonde moment.

Thanks - worked great!

FYI - I tried this with another application and it entered line returns, thereby destroying the table structure. This was beauty!


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest