Link to home
Start Free TrialLog in
Avatar of bpfsr
bpfsrFlag for United States of America

asked on

parse the next line in outlook

If

If intLocLabel > 0 Then
       strText = Left(Trim(Mid(strSource, intLocLabel + 14)), 9)
       intLenLabel = Len(strText)

parses a 9 digit number just after my key phrase, how would I parse all the information on the next line?
Avatar of Naveen Swamy
Naveen Swamy

not clear with your question???????
i think we need to know some more about the formatting....


however to speed this up, you can place $ signs right to Left,Trim and Mid like this:

strText = Left$(Trim$(Mid$(strSource, intLocLabel + 14)), 9)

that is about 20% faster
Avatar of bpfsr

ASKER

Sorry - what I'm saying is I use the code above to parse a particular number from the same line as the LocLabel. In this case it is a reference numbers, so I am searching for the phrase "reference #:" and then parsing the number itself, which always falls immediately after "reference #:" and is always on the same line. However, I want to seperately parse, for insertion somewhere else, the line beneath "reference #:". So if  - strText = Left$(Trim$(Mid$(strSource, intLocLabel + 14)), 9) - gives me the number following "reference #:", how do I get the line beneath it?
ASKER CERTIFIED SOLUTION
Avatar of Mark_FreeSoftware
Mark_FreeSoftware
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial