take all characters after _

[jasonhuibers]

strVar = 'abc123456_aa.bb'

I only want to take aa.bb from this variable... basically everything after the '_'

How can I do this

 

[PHV]

Mid(strVar, 1 + InStr(strVar, "_"))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[oldenny]

'VBScript:

strVar = "abc123456_aa.bb"

strArray = Split(strVar, "_")

'result:
' strArray(0) -> "abc123456"
' strArray(1) -> "aa.bb"

'OR:

strResult = Right(strVar, Len(strVar) - InStrRev(strVar, "_"))

MsgBox strResult

 

[dm4ever]

Option Explicit

Dim strTemp : strTemp = "abc_123456_aa.bb"

Dim RegEx : Set RegEx = New RegExp
RegEx.Pattern = "\_([^_]+\.\w+)"
RegEx.IgnoreCase = True

WScript.Echo RegEx.Execute(strTemp)(0).SubMatches(0)

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid