String headache

[arcticpup]

Hi,

Having given myself a headache trying to work this one out, looking at stringsplit and searching the forums etc.....

What I want to do is read a reg value as a variable (so far so good)

This key will usually(but not always) contain a backslash (it is refering to a servername and sql instance so would normally by server\instance) but obviously server and instance name may change in name and length.

what I want to do is read this as a variable and strip out everything after the backslash (including the backslash itself)

Any help would be appreciated

Thanks

[Josbe]

Hi,

Having given myself a headache trying to work this one out, looking at stringsplit and searching the forums etc.....

What I want to do is read a reg value as a variable (so far so good)

This key will usually(but not always) contain a backslash (it is refering to a servername and sql instance so would normally by server\instance) but obviously server and instance name may change in name and length.

what I want to do is read this as a variable and strip out everything after the backslash (including the backslash itself)

Any help would be appreciated

Thanks

Do you have some code already? (To start)

[Authenticity]

$sServ = StringRegExp($sValue, '(.*)\\', 1)
If IsArray($sServ) Then 
    ; Success
Else
    ; Failure
EndIf

If it may not contain a backslash then you may want to change '\\' to '\\?'.

[Szhlopp]

Hi,

Having given myself a headache trying to work this one out, looking at stringsplit and searching the forums etc.....

What I want to do is read a reg value as a variable (so far so good)

This key will usually(but not always) contain a backslash (it is refering to a servername and sql instance so would normally by server\instance) but obviously server and instance name may change in name and length.

what I want to do is read this as a variable and strip out everything after the backslash (including the backslash itself)

Any help would be appreciated

Thanks

RegexReplace!

Pattern:

CODE

\\.*

Replace:

CODE

Should look like:

CODE

$ServerName = StringRegExpReplace($Text, "\\.*", "", 0)

Also there is an SRE tester in my sig thatw ill help you a lot for learning how to do these=)

Edited March 17, 2009 by Szhlopp

[Drew]

Edit: DAMN you'll are fast O_O.

They went more in depth than I did .

Edited March 17, 2009 by Drew

[arcticpup]

RegexReplace!

Pattern:

CODE

\\.*

Replace:

CODE

Should look like:

CODE

$ServerName = StringRegExpReplace($Text, "\\.*", "", 0)

Also there is an SRE tester in my sig thatw ill help you a lot for learning how to do these=)

Fantastic! Such a simple solution. Many thanks for all your advice!