• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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

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
0
Karen Schaefer
Asked:
Karen Schaefer
  • 2
1 Solution
 
Patrick MatthewsCommented:
Hi Karen,

Replace the pattern string "\d{4}" with the pattern string "[""\d]{4,6}"

Regards,

Patrick
0
 
Patrick MatthewsCommented:
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
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now