InStr VB.net question

Trampas · 13-11-2006 02:25PM #1

Hi,

I have the following string

AVSADDRESSRESULT =
AUTHCODE =
PASREF = 11616951961804
MERCHANT_ID = es
ORDER_ID = 3000036
TIMESTAMP = 20061024140636
RESULT = 103

I need to strip over the value after result but when I do a InStr it picks up the result in the avsaddressresult.

Can I get my code to skip this one and select the next one?

intPos = InStr(1, UCase(strOrderText), "RESULT=")

amen · 13-11-2006 02:43PM

loads of ways to do this
you could Split the string and seach the array positions
or
if you have a match check to makes sure there are not additional characters to either side and if there are restart the search
or
if the format is alwasy with same with the result you are looking for at the end then use RevInStr or maybe its InStrRev (can't remember)

cyberbob · 13-11-2006 08:32PM

amen wrote:

loads of ways to do this

alot of which are overkill...

Trampas wrote:

Can I get my code to skip this one and select the next one?

intPos = InStr(20, UCase(strOrderText), "RESULT=")
ie start the search after "AVSADDRESSRESULT"

again as amen said, assuming your output is always that format.

Ginger · 13-11-2006 08:59PM

Or just use InStrRev for attacking it from the other end

mewso · 14-11-2006 01:31AM

So has nobody moved on to using the string object methods. i.e.
intPos = strOrderText.ToUpper.IndexOf("RESULT=", 20)

I always assumed the new methods were more efficient but who knows.

amen · 14-11-2006 03:05PM

what the 20 for?

mewso · 14-11-2006 04:09PM

20 is the start position as per cyberbob's suggestion.
The other option is to find the bit before the RESULT part you want:-

intPos = strOrderText.ToUpper.IndexOf("TIMESTAMP =")
intPos = strOrderText.ToUpper.IndexOf("RESULT =", intPos) 'should always find the result string after timestamp avoiding the result string at the beginning.

theslick · 15-11-2006 12:12PM

if those are linefeeds

intPos = InStr(1, UCase(strOrderText), vbCrLF + "RESULT = ")

InStr VB.net question

Comments