Solved

String problem??

Posted on 2004-08-15
2
155 Views
Last Modified: 2010-05-02
I pull in the following string from a URL and would like to start parsing at: 'Manager:' under 'Edit Job Contacts' which I can do.  But then when I want to parse the 'Primary:' under the 'Edit Job Contacts' I pull in the first 'Primary' under the:' Edit Application Contacts'. So, how can I start parsing the second group of contacts not the first.
 

myString = "Job Completion: client
Edit Application Contacts Manager: Tim Jones - Ext: 3893
Primary: Rick James - Ext: 3214
Secondary: Sue Thomas - Ext: 4821
Tertiary: Dan Stevens - Ext:

Edit Job Contacts Manager: Tom Peters - Ext: 5550
Primary: Paul Winter - Ext: 5155
Secondary: Tim Williams - Ext: 7145
Tertiary: Terry Olson - Ext: 7145"


Thanks

0
Comment
Question by:rkckjk
2 Comments
 
LVL 8

Expert Comment

by:mladenovicz
ID: 11804090
You should ignore the fisrt contact. I don't know how you parse this string, but if you use InStr function, you can specify start position (to ignore the first contact)
0
 
LVL 15

Accepted Solution

by:
Colosseo earned 125 total points
ID: 11804099
Hi

do you want to do anything with the first group? You could always just strip it out using something like this

myString = Mid(myString, InStr(myString, "Edit Job Contacts Manager:"))

That should leave you with

myString = "Edit Job Contacts Manager: Tom Peters - Ext: 5550
Primary: Paul Winter - Ext: 5155
Secondary: Tim Williams - Ext: 7145
Tertiary: Terry Olson - Ext: 7145"

Now when you parse Primary it will reuturn Paul Winter

HTH

Scott
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now