[RESOLVED] vba tokenizer .. excel?
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
Re: vba tokenizer .. excel?
are there spaces other than delimiters?
if not you can remove all additional space then split
vb Code:
strtxt = filecontent
do until strlen = len(strtxt)
strlen = len(strtxt)
strtxt = replace(strtxt, " ", " ") 'replace double space with single space till all gone
loop
Re: vba tokenizer .. excel?
worked perfectly..
thanks much!