extract value from string

[FoxKid]

I am having a string like this
"asdga/ser"
"asd/sdagasdfg"
"asdf_asd/asdfg"
Now I want to pick the value as follows
"asdga"
"asd"
"asdf_asd"
How is it possible?

Thanks n Regards

 

[IoriYagami]

?SUBSTR("asdga/ser",1,AT("asdga/ser",'/')-1)
?SUBSTR("asd/sdagasdfg",1,AT("asd/sdagasdfg",'/')-1)
?SUBSTR("asdf_asd/asdfg",1,AT("asdf_asd/asdfg",'/')-1)

 

[FoxKid]

Thanks IoriYagami
But u have done a small mistake.....
it should be like this
?SUBSTR("asdga/ser",1,AT('/',"asdga/ser&quot-1)
?SUBSTR("asd/sdagasdfg",1,AT('/',"asd/sdagasdfg&quot-1)
?SUBSTR("asdf_asd/asdfg",1,AT('/',"asdf_asd/asdfg&quot-1)

Thankyou once again for your idea....

 

[IoriYagami]

Thanks for correcting my mistatke... Ha... do u ever try the SuperCombo From Chris in the faq184-1891. If yes pls let me know the result...

 

[rgbean]

FoxKid,
This is one of those times when using a function for other than what it was written for also works:

?JUSTPATH("asdga/ser")
?JUSTPATH("asd/sdagasdfg")
?JUSTPATH("asdf_asd/asdfg")
or in VFP 7 & 8
?getwordnum("asdga/ser",1,"/")
?getwordnum("asd/sdagasdfg",1,"/")
?getwordnum("asdf_asd/asdfg",1,"/")
or in VFP 6
set library to home()+"foxtools.fll"
?wordnum("asdf_asd/asdfg",1,"/")
...

Rick