Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Regular Expression replace

Status
Not open for further replies.

Dawg06

Programmer
Jul 24, 2006
13
CA
I need to remove both ( and ) and any empty spaces from a string. I know I need to use replace and a regular expression but have no clue how to write the expression. Can someone help me with this?

Replace(sting,"?","","ALL")
 
Replace(sting," ","","ALL")

Will do it. It's not a regex but as you described your requirement none should be needed.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top