I am downloading files for work that have multiple variations of <font color="#CCCCCC">
at the end of every line of text. How would I (as either Regular Expressions or a Basic macro) delete brackets and anything in between them?
Thanks
Cam!
I am downloading files for work that have multiple variations of <font color="#CCCCCC">
at the end of every line of text. How would I (as either Regular Expressions or a Basic macro) delete brackets and anything in between them?
Thanks
Cam!
Try the regular expression <.*>
as your search and empty as your replace. Remember to check Regular expressions and try it on a copy of your data, as I don’t claim to be a regex expert This will capture all angle brackets; if you specifically need only the tag at the end of a line, try <.*>$
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.
That’s it!! Thank you so much!