[RESOLVED] vba tokenizer .. excel?

[pgag45]

Hey all,

I'm reading in a rather large text file... which, not by my own choice, is delimited by different amounts of white space. The numbers/strings within the file are of different length. I need to cut between the whitespace and put each value into a respective cell creating a table. After some google research I couldn't find a vb tokenizer or something of the like. Am I forced to write a couple loops to essentially create my own tokenizer?

Thanks much,

PG

[westconn1]

are there spaces other than delimiters?
if not you can remove all additional space then split

strtxt = filecontent
do until strlen = len(strtxt)
    strlen = len(strtxt)
    strtxt = replace(strtxt, "  ", " ")    'replace double space with single space till all gone
loop

[pgag45]

worked perfectly..

thanks much!