troubleshooting Question

Extract and split string

Avatar of nellster
nellster asked on
Visual Basic Classic
8 Comments4 Solutions268 ViewsLast Modified:
Hi All. Am running IIS6 / .Net Framework / working in ASP.NET using Visual Basic.NET.

I have some "contacts" data imported from a CSV into an Access Database. The troublesome field is the "Phone" field as it contains text and numbers, for example "Office phone: 0234 132432Cell phone: 07865 99999". What I need to be able to do is extract the "office phone" number to a seperate "Office Phone" field, same for "Cell Phone" and I think there are some "Office Fax" numbers as well.

I have performed string manipulation before but am a bit stumped by this.

Any help would be gratefully recieved!

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 4 Answers and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros