Required the first part of string from right

[veer]

i have a string
c:\var\newdata\ 123456\123456_1 .mdb
i want the first part of string from right side
l,e 123456_1.mdb

how is it possible please send me some code

[QVeen72]

i have a string
c:\var\newdata\ 123456\123456_1 .mdb
i want the first part of string from right side
l,e 123456_1.mdb

how is it possible please send me some code

Hi,

Use this :

[code=vb]
Dim str1 As String
Dim TArr
str1 = "c:\var\newdata \123456\123456_ 1.mdb"
TArr = Split(StrRevers e(str1), "\")
MsgBox StrReverse(TArr (0))
[/code]

Regards
Veena

[veer]

thanks
it is working because i am very confused over it

Hi,

Use this :

[code=vb]
Dim str1 As String
Dim TArr
str1 = "c:\var\newdata \123456\123456_ 1.mdb"
TArr = Split(StrRevers e(str1), "\")
MsgBox StrReverse(TArr (0))
[/code]

Regards
Veena