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,",");