I have searched for this, but the results have not worked out for me.
I am trying to use Regex to find/replace in Eclipse and I think I'm close.
For example, I want to search this text and find 'Award'.
<columns>
<field>Opportunity.Site_Country__c</field>
</columns>
<currency>USD</currency>
<filter>
<criteriaItems>
<column>STAGE_NAME</column>
<operator>equals</operator>
<value>Award,Award.,Order</value>
</criteriaItems>
<language>en_US</language>
</filter>
<format>Tabular</format>
<name>opportunity site update</name>
My attempt is this which somewhat works:
(?<=\<column>STAGE_NAME<\/column>[\s\S]*)(Award\b)(?=[\s\S]*<\/value>[\s\S]*<\/criteriaItems>)