Removing HTML from excel column

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Removing HTML from excel column

Post by 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: 2230
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Removing HTML from excel column

Post by 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

Post by 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!

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest