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!

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

string help needed

Status
Not open for further replies.
perto

perto

IS-IT--Management
Sep 21, 2000
10
0
0
BE
Hi all,
can anybody help me with the following :

I want to remove characters from a string containing a telephone number for ex. :
0049(0)654654646 what I want to do is put that in a new string without (0) in it.

thanx in advance
perto
 
Sort by date Sort by votes
Function ParsePhone(strPhone As String)
Dim intParen As Integer
intParen = InStr(strPhone, "(")
ParsePhone = Left(strPhone, intParen - 1) & Mid(strPhone, intParen + 3)
End Function


PaulF
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
331
dhookom
dhookom
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
69
dhookom
dhookom
mwiinde
  • Locked
  • Question
How to Convert Ms Access query data into Json String
Replies
0
Views
77
mwiinde
mwiinde
TheresAlwaysAWay
  • Locked
  • Question
Need help finding where a number lies within a set of values 1
Replies
3
Views
67
TheresAlwaysAWay
TheresAlwaysAWay
jguesman14
  • Locked
  • Question
Creating a Database....Help!
Replies
1
Views
45
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top