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 = ""
Replied: 10/25/2017 12:32:37 PM
class="(.*?)"
replace ""
(.*)
insert "$$1"

thought i would post the final version. This works tip top!. Replace class with whatever tag required. HTML on input or extract html element for this to work in visual web ripper.

Cheers
Replied: 10/25/2017 2:11:51 PM

Hi,

This website is helpful for regex learning, https://www.regular-expressions.info/tutorial.html

Replied: 10/25/2017 12:33:28 PM
I wish there was a depository for people to leave lots of code snippets with a support to describe exactly what it is and does. Regex section would be nice :0)