Solved: Split field

[boneKrusher]

Hi all,

I am in need of some help.

How do I split a field in MS Access using VBA?



c:temp\files\blah.pdf

I want the file name only.

"blah.pdf"

thanks for the help

[boneKrusher]

I found it digging through the archives:


Function GetFileName(ByVal Path As String) As String
Dim sParts() As String
sParts = Split(Path, "\")
GetFileName = sParts(UBound(sParts))
End Function

[andrew93]

[post deleted - you found the answer]