extract a string
extract a string
(OP)
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 :)
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 :)





RE: extract a string
...\Mayrou\...
RE: extract a string
Bellow is an example using different functions (just to understand how is working),
CODE --> vbs
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 FinalStringor in your code
CODE --> vbs
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: extract a string