Solved

String problem??

Posted on 2004-08-15
2
160 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: 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!

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

734 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