Latest Inquiries - Data Extraction Software

stripping out a class

Submitted: 8/15/2017
Hi there

I seem to have a table with some cells that only select one cell instead of a list of cells. It's down to the class tags being different in some columns.

Is there away to strip out the classes via transformation. (regex)

example

class="ftq_4 ftq_5_1" id="cross_rate_1" style="margin: 0px; padding: 0px; width: 559px;" border="0" cellSpacing="0" cellPadding="0"><tbody><tr class="arial_11_white_b ftq_5"><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap=""><nobr>Symbol</nobr></td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Bid</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Ask</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Last</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Open</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">High</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Low</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Chg.</td><td class="ftqw2 ftqh ftqa11wb ftqac" noWrap="">Chg. %</td></tr><tr class="arial_11 ftqtr1" id="pair_3" style="background-color: #f6f6f6;">

I would like to see .. as in totally blank... keeping everything neutral.

Any help would be welcomed

Thanks


Replied: 8/31/2017 5:11:08 PM
Thanks works a treat!
Replied: 8/21/2017 5:27:46 AM

You can try to use 

[A-z]+".*?"

replace 

this will remove all the classes. 

Replied: 8/15/2017 1:17:06 PM
"class = ""