Split the string till specific substring

See more:

macros

MS-Word

I have a reference list, I have to compare author's name with citation authors. I have to split the string till the year,So that I can get only author names. but I don't have an idea how to proceed further.

For example:

txt="Sperrin, M., Jaki, T., & Wit, E. (2010). Probabilistic relabelling strategies for the label switching problem in Bayesian mixture models. Statistics in Computing, 20, 357-366."

- This is the text from which I have to extract the author name


I have tried so far...

dim txt as string
    dim txtarray() as string
    txt="Sperrin, M., Jaki, T., & Wit, E. (2010). Probabilistic relabelling
    strategies for the label switching problem in Bayesian mixture models. 
    Statistics in Computing, 20, 357-366."
    txtarray=split(txt,",");
    'here I have to split the string till year because it will split all the
    'words which have comma with it.I need only the author's name.So, here I got 
    'struck how to get split string only till year.
    '??????