Tokenizing Strings

ms-word, tokenize, vba

Solution

You could read line by line and use the split function to split the word and number by space. I vaguely remeber VBA has the split function.

I got the following link by searching in google. Not sure which version of office you are using.

http://msdn.microsoft.com/en-us/library/aa155763(office.10).aspx

This link has the split function.

Problem

I have around 100 rows of text that I want to tokenize, which are alike the following: ``` <word> <unknown number of spaces and tabs> <number> ``` I am having trouble finding tokenize functions with VBA. What would be the easiest method to tokenize such strings in VBA?

Original source