Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: String manipulation


Message #1 by "Anita Elenbaum" <aelenbaum@s...> on Fri, 9 Nov 2001 14:33:42
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C17245.CD3929F0
Content-Type: text/plain;
	charset="iso-8859-1"

Phone = "(248) 351-7749"

Phone = Replace(Phone, "(", "")
Phone = Replace(Phone, ")", "")
Phone = Replace(Phone, " ", "")
Phone = Replace(Phone, "-", "")

-Fergal


-----Original Message-----
From: Anita Elenbaum [mailto:aelenbaum@s...]
Sent: Saturday, 10 November 2001 01:34 AM
To: professional vb
Subject: [pro_vb] String manipulation


I have a phone number that looks like this (248) 351-7749.
Want to strip the "(", ")", "-", and any spaces, so that I 
end up with 2483517749.  

What is the best way to do this?

Thanks, Anita



  Return to Index