Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

String problem??

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
Richard Kreidl
Asked:
Richard Kreidl
1 Solution
 
mladenoviczCommented:
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
 
ColosseoCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now