How would I trim this?

[Prodigus]

I just want to grab the IP address out of this string

6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194) is alive.

I would thing there would be a function where I could just grab whatever is between "(" and ")"

Is there?

The count would be different from left or right depending on the date and the IP address so I didn't think I could do it with a StringTrimLeft or right...

[exodius]

I just want to grab the IP address out of this string

6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194) is alive.

I would thing there would be a function where I could just grab whatever is between "(" and ")"

Is there?

The count would be different from left or right depending on the date and the IP address so I didn't think I could do it with a StringTrimLeft or right...

Check out StringSplit in the helpfile for more info on how this works...

$string = "6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194)"

$Split = StringSplit ( $string, "(" )
$Split2 = StringSplit ( $Split[2], ")" )

MsgBox ( 0, "", $Split2[1] )

Edited June 4, 2006 by exodius

[Nomad]

$String = StringSplit ( "6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194) is alive.", "(" & ")")
MsgBox(0, "Return", $String[2])

Enjoy,

Nomad

[exodius]

$String = StringSplit ( "6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194) is alive.", "(" & ")")
MsgBox(0, "Return", $String[2])

Enjoy,

Nomad

Fancy, I didn't know you could concatenate them like that. I understand how splitting the string at "(" gives you [2], but wouldn't you need the [1] of ")"? Edited June 4, 2006 by exodius

[Nomad]

Fancy, I didn't know you could concatenate them like that.

Yup.

We were posting at the same time so I didn't see yours until I posted mine, hehe.

[RazerM]

I would prefer to use stringbetween. They produce the same results and stringbetween is easier to use.

$string = "6/4/2006 12:10:46 PM | 23T7111.my.com (10.100.51.194) is alive."
$ip = StringSplit ( $string, "()")
MsgBox(0, "StringSplit", "The ip is: " & $ip[2])
MsgBox(0, "StringBetween", "The ip is: " & _StringBetween($string, "(", ")"))

Func _StringBetween($s, $from, $to)
    $x = StringInStr($s, $from) + StringLen($from)
    $y = StringInStr(StringTrimLeft($s, $x), $to)
    Return StringMid($s, $x, $y)
EndFunc

Edited June 4, 2006 by RazerM

[exodius]

Fancy, I didn't know you could concatenate them like that. I understand how splitting the string at "(" gives you [2], but wouldn't you need the [1] of ")"?

Just came to the realization that concatenating them like that splits the string up based upon those two characters instead of just one.

[Nomad]

Just came to the realization that concatenating them like that splits the string up based upon those two characters instead of just one.

I had to do a lot of string extracting not too long ago, so I got a lot of experience with using that command. Saved me a lot of lines in my script.

[Prodigus]

Thanks!!!!!

Solves a big problem I was having......

[Valuater]

I had to do a lot of string extracting not too long ago, so I got a lot of experience with using that command. Saved me a lot of lines in my script.

that is a nice, new one to me too!!

8)