extract a string

[mayrou]

Hello world!
I want to extract a string from an other
for example dossier1\dossier2...\123-Mayrou\forum
for that I used SPLIT to extract "mayrou"

mayrou =Right(Split(productDocument1.Path,"\")(2),4)

Anybody please correct it.
Thanks in advance

 

[mayrou]

I want to extract a string between two
...\Mayrou\...

 

[ferdo]

Depending on what you want to extract (and which language are you using, for example is much easier in vb.net) it can be done in different ways

Bellow is an example using different functions (just to understand how is working),

Dim MyString, TrimString, RightTrimString, FinalString

MyString = "dossier1\dossier2\123-Mayrou\forum" 

MyStringNr = Len(MyString)
MsgBox MyStringNr

LeftTrimStringNr = InStr(MyString, "Mayrou")
MsgBox LeftTrimStringNr

RightTrimString=Right(MyString, MyStringNr - (LeftTrimStringNr-1))
MsgBox RightTrimString

FinalString = Left(RightTrimString,Len("Mayrou"))
MsgBox FinalString

or in your code

Dim MyString, FinalString

MyString = "dossier1\dossier2\123-Mayrou\forum" 
strToExtract = "Mayrou"
FinalString = Right(Split(MyString, "\")(2),Len(strToExtract))
MsgBox FinalString

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

https://picasaweb.google.com/103462806772634246699/

 

[mayrou]

thx you Fernando