Search Strings

[gerwim]

Hi guys,

So, let's say I have this string: "<OPTION value=6>Test</OPTION>".

How can I get the number "6"? There's lot more <options> in there normally. And I want to search for "Test" (so by searching the string for Test, I want 6 as return).

Thanks in advance!

[saywell]

The elegant way is by using a regular expression, but they're hard!

Try _StringBetween - using = and >Test as the delimiters. That's assuming there aren't any other = signs in the line.

William

[gerwim]

The elegant way is by using a regular expression, but they're hard!

Try _StringBetween - using = and >Test as the delimiters. That's assuming there aren't any other = signs in the line.

William

There will be like 40 options in the complete string.. =(

[JohnOne]

heres one way

#include <String.au3>

$s = "<OPTION value=6>Test</OPTION>"

If StringInStr($s,"Test",1) Then
    $return = _StringBetween($s,"=",">")
EndIf
MsgBox(0,"",$return[0])

[gerwim]

heres one way

#include <String.au3>

$s = "<OPTION value=6>Test</OPTION>"

If StringInStr($s,"Test",1) Then
    $return = _StringBetween($s,"=",">")
EndIf
MsgBox(0,"",$return[0])

Thanks John, but this will not work due to be more then one option. The complete string will be something like this:

<OPTION value=6>Test</OPTION><OPTION value=7>Test1</OPTION><OPTION value=8>Derp</OPTION><OPTION value=9>Test3</OPTION><OPTION value=10>Blabla4</OPTION>

Edited March 3, 2011 by gerwim

[JohnOne]

Then the rexexp suggestion above probably the best, I sheepishly work around regexp though.

You could do it many different ways using string functions.

heres an option using native string* functions

$s = "<OPTION value=6>Test</OPTION><OPTION value=7>Test1</OPTION><OPTION value=8>Derp</OPTION><OPTION value=9>Test3</OPTION><OPTION value=10>Blabla4</OPTION>"

$a = StringSplit($s,"<OPTION value=",3)

$searchstring = "Blabla4"

For $i = 0 To Ubound($a) -1
If StringInStr($a[$i],$searchstring,1) Then
    $return = StringTrimRight($a[$i],10+StringLen($searchstring))
EndIf
Next
MsgBox(0,"",$return)

[Melba23]

gerwim,

Do you want just the single digit preceding the "Test" or an array of the digits preceding all the "Test?" elements?

M23

Edit: Easier than I thought:

#include <Array.au3>

$sString = "<OPTION value=6>Test</OPTION><OPTION value=7>Test1</OPTION><OPTION value=8>Derp</OPTION><OPTION value=9>Test3</OPTION><OPTION value=10>Blabla4</OPTION>"

$iDigit = StringRegExpReplace($sString, "(?i).*value=(\d+)>Test<.*", "$1")

MsgBox(0, "Result", $iDigit)

$aArray = StringRegExp($sString, "(?i)value=(\d+)>Test", 3)

_ArrayDisplay($aArray)

And my brain did not hurt too much!

Edited March 3, 2011 by Melba23

[gerwim]

Then the rexexp suggestion above probably the best, I sheepishly work around regexp though.

You could do it many different ways using string functions.

heres an option using native string* functions

$s = "<OPTION value=6>Test</OPTION><OPTION value=7>Test1</OPTION><OPTION value=8>Derp</OPTION><OPTION value=9>Test3</OPTION><OPTION value=10>Blabla4</OPTION>"

$a = StringSplit($s,"<OPTION value=",3)

$searchstring = "Blabla4"

For $i = 0 To Ubound($a) -1
If StringInStr($a[$i],$searchstring,1) Then
    $return = StringTrimRight($a[$i],10+StringLen($searchstring))
EndIf
Next
MsgBox(0,"",$return)

Thanks, will look into that!

gerwim,

Do you want just the single digit preceding the "Test" or an array of the digits preceding all the "Test?" elements?

M23

No, just single digit, non array.

[Melba23]

gerwim,

Our posts crossed - see my edit above!

M23

[gerwim]

gerwim,

Our posts crossed - see my edit above!

M23

Damn, awesome. Gotta learn regexes.. Thanks!