Community

I need to replace a string...

<ReportTable1>[EmbeddedReport1]efrm goes here[/EmbeddedReport1]

with empty string. So I guess it might better be described as finding and deleting the string<ReportTable1>[EmbeddedReport1]efrm goes here[/EmbeddedReport1]

The number 1 could be any number from 1-99.

Also what would I need to do if the string was <ReportTable1> and not the longer string?

Thanks

I figured out the short string. I will apply it to the longer string and see if it works as well.


ReportInstance = 1

strSearchString = "\<ReportTable efrm" & ReportInstance & "\>"

If I'm understanding you, this regular expression would work:
This assumes the number is the same in all locations throughout the line.