LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Iterate through all words

I have a text file that is read and stored into a string variable.
Here is the basic code:

Dim s as String

s = ReadTextFile("C:\data.txt")

I would now like to retrieve each and every word that is
stored in the variable "s". Loading all the words into an
array will be okay for now.

For my purposes, a word is any string of characters that
does not include whitespace characters, such as spaces,
tabs, carriage returns, line feeds, etc... I think those are
the only whitespace characters that exist, right?

Gary, do you recommend that I use the Split() function for this?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate Thru Cells Kelvin Excel Programming 4 September 5th 07 10:18 AM
Iterate through a form RobEdgeler Excel Programming 2 September 17th 05 06:58 PM
Iterate through controls lgbjr Excel Programming 3 May 28th 05 02:09 PM
Can't iterate thru a row with For peter Excel Programming 2 January 7th 05 04:46 AM
Iterate columns wired Excel Programming 9 November 14th 03 11:14 PM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"