Access String Tokenizer

[paulig2001]

Is there any way, either through VBA, or queries or whatever to implement something similar to a Java String Tokenizer in Access?

What I want to do is change a big mad list of names, like "John O'Brien" to a list something like "johnobrien", for the purpose of accessing image files with names in that format, eg "johnobrien.jpg"

 

[Mile-O]

Public Function Tokenise(ByVal strName As String) As String
    strName = Replace(strName, " ", vbNullString)
    strName = Replace(strName, "'", vbNullsting)
    strName = StrConv(strName, vbLowerCase)
    Tokenise = strName
End Function

 

[paulig2001]

Public Function Tokenise(ByVal strName As String) As String
    strName = Replace(strName, " ", vbNullString)
    strName = Replace(strName, "'", vbNullsting)
    strName = StrConv(strName, vbLowerCase)
    Tokenise = strName
End Function

Cheers boss!