<div>
Karen,<br />
<br />
BTW, when you post a new question that draws on previous questions, it is a good idea to add a link to the past question(s).<br />
I knew what was going on, but other Experts are probably scratching their heads and thinking, what the heck is RegExpReplace?<br />
That's not a native function?!?<br />
<br />
:)<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Karen,

BTW, when you post a new question that draws on previous questions, it is a good idea to add a link to the past question(s).
I knew what was going on, but other Experts are probably scratching their heads and thinking, what the heck is RegExpReplace?
That's not a native function?!?

:)

Regards,

Patrick

<div>
<div class="content wysiwyg-content">
How do I modify this code to include the quote in Call ######## Enter Pin &quot;3000&quot;. &nbsp;I need to eliminate the quotes surrounding the number and replace it with ####.<br />
<br />
SomeVar = RegExpReplace(RegExpReplac<wbr />e(RegExpRe<wbr />place(Some<wbr />String, &quot;<a href="http://" rel="ugc nofollow">http://</a>[^ ]*&quot;, &quot;<a href="http://" rel="ugc nofollow">http://</a>&quot;, True, False), &quot;[\d\.\-\(\)]{7,}&quot;, &quot;##########&quot;, True, False), &quot;\d{4}&quot;, &quot;####&quot;, True, False)<br />
<br />
Thanks,<br />
<br />
Karen
</div>
</div>


How do I modify this code to include the quote in Call ######## Enter Pin "3000".  I need to eliminate the quotes surrounding the number and replace it with ####.

SomeVar = RegExpReplace(RegExpReplace(RegExpReplace(SomeString, "http://[^ ]*", "http://", True, False), "[\d\.\-\(\)]{7,}", "##########", True, False), "\d{4}", "####", True, False)

Thanks,

Karen

Continued from Question #Q_21781278 - regarding a function to replace text within a string continued

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.