remove anything between two strings in vba

[starlev]

I’m looking to build code to remove anything between two strings in vba.


For example anything between .

<iframe

And

</iframe>




For example my original string is

<div class="col-md-6 col-xs-12 noPadLeft">

<iframe class="produ" src="gmail.com" allowfullscreen="" width="600" height="600" frameborder="0">

</iframe>

</div>

And the new string I would like is

<div class="col-md-6 col-xs-12 noPadLeft">
</div>

How can this be done?

Is there way to do this with a regular expression?

 

[Zot]

I guess in your code the possibility of <iframe and </iframe to be on the same row is nil, right? This would be simpler handle. If not, you can use Instr to find start (<iframe) and end (</iframe) position and remove anything in between.

Instead of RegEx which is not native to VBA, Like can be used also, I suppose.

 

[Rick Rothstein]

Does the existing text have multiple Line Feeds like your example shows?

For the output you want, do you want the multiple Line Feeds removed like your example shows?

Is it possible for the delimiter tags and their included text that you want removed to appear more than once in your existing text?

 

[Peter_SSs]

Also ..
Where is the original string? Is it in a worksheet cell? Is it held in a vba string variable? (not likely I guess with those internal quotes). Somewhere else?