strings

[kevcar40]

Hi
I have created a hyperlink to a document
what i would like to do is read the string and return only the file
name
i will need to read from the right untill i read the full stop(.) and
exclude this
i then need to read from the right untill i read the first \ this will
give me the file name
from here i need to discard the rest of the file path leaving only the
file name
i am then going to display the file name in a combox box for the user
to open the document

i have tried the display text but cant find a way to automatically do
this
can anyone help please
thanks
kevin

[Wayne Gillespie]

On 26 Jan 2006 03:05:44 -0800, "kevcar40" <ke******@btinternet.com> wrote:

Hi
I have created a hyperlink to a document
what i would like to do is read the string and return only the file
name
i will need to read from the right untill i read the full stop(.) and
exclude this
i then need to read from the right untill i read the first \ this will
give me the file name
from here i need to discard the rest of the file path leaving only the
file name
i am then going to display the file name in a combox box for the user
to open the document

i have tried the display text but cant find a way to automatically do
this
can anyone help please
thanks
kevin

Function fGetFileName(strPath As String) As String
Dim intEndPos As Integer
Dim x As Integer

intEndPos = 1
Do Until InStr(intEndPos, strPath, "\") = 0
x = InStr(intEndPos, strPath, "\")
intEndPos = x + 1
Loop

fGetFileName = Mid(strPath, intEndPos, (InStr(1, strPath, ".") - intEndPos))

End Function

Wayne Gillespie
Gosford NSW Australia

[kevcar40]

Thank you wayne
Could you tell me how to call this function and assign the reult to a
text box

thanks again

kevin

[Wayne Gillespie]

On 26 Jan 2006 03:55:04 -0800, "kevcar40" <ke******@btinternet.com> wrote:

Thank you wayne
Could you tell me how to call this function and assign the reult to a
text box

thanks again

kevin

Add a text box and as the RecordSource put

=fGetFileName([ControlContainingPath])

Change [ControlContainingPath] to the name of your HyperLink control containing the path and filename.
Wayne Gillespie
Gosford NSW Australia

[kevcar40]

Thank you
works a treat

kev