bpfsr
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?
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?
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
however to speed this up, you can place $ signs right to Left,Trim and Mid like this:
strText = Left$(Trim$(Mid$(strSource
that is about 20% faster
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.