12-21-2006, 05:26 AM
How do I remove double quotes or replace double quotes to blank space or single quotes in a string? For example in the single long string below (no hard returns in this single string):
<TD vAlign=center><SELECT class=actionBoxdb id=s2 style="WIDTH: 75px" onchange=parent.DoFunction(event.srcElement) LeafletPath="" PrescriptionID="f754524a-8cc3-4eb9-819d-de3d85bdcc0e" scriptid="f754524a-8cc3-4eb9-819d-de3d85bdcc0e" statustask="" statusnotes="" status="0" Quantity="30" Refills="prn" SIG="1 po qAM" Dose="30 mg" Prescription="Prevacid"><OPTION value=details selected>details</OPTION><OPTION value=stop>stop</OPTION><OPTION
I want to remove or replace all double quotes and THEN match the "s2" when it follows "id=" (lookbehind) and precedes "Prevacid" (lookahead). I can't seem to use regular expressions until the double quotes are removed and I can't use regular expressions to remove the double quotes either. Should I use Vbscript RegEx to first remove the quotes and then return to using PCRE in QuickMacros?
<TD vAlign=center><SELECT class=actionBoxdb id=s2 style="WIDTH: 75px" onchange=parent.DoFunction(event.srcElement) LeafletPath="" PrescriptionID="f754524a-8cc3-4eb9-819d-de3d85bdcc0e" scriptid="f754524a-8cc3-4eb9-819d-de3d85bdcc0e" statustask="" statusnotes="" status="0" Quantity="30" Refills="prn" SIG="1 po qAM" Dose="30 mg" Prescription="Prevacid"><OPTION value=details selected>details</OPTION><OPTION value=stop>stop</OPTION><OPTION
I want to remove or replace all double quotes and THEN match the "s2" when it follows "id=" (lookbehind) and precedes "Prevacid" (lookahead). I can't seem to use regular expressions until the double quotes are removed and I can't use regular expressions to remove the double quotes either. Should I use Vbscript RegEx to first remove the quotes and then return to using PCRE in QuickMacros?