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 Efficient storage

I would like to find all the unique words in a text file and store them
in an Excel 2010 spreadsheet. I am looking for a reasonably
efficient method or algorithm to achieve this.

I was thinking, how about save all the words that begin with "A"
in the A column, all the "B" words get placed in the B column,
etc...

Also, each word should only be stored ONCE in the spreadsheet,
regardless of lowercase, uppercase, mixed, etc. So, if my text
file contains "apple", "APPLE", or "aPPle", only one instance of
"apple" should appear under the A column.

I'd appreciate anything to help me get started. Thank you.

Robert



 
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
XML Data Storage Rookie_User Excel Discussion (Misc queries) 0 June 30th 08 07:11 PM
Persistent Storage for Add-Ins ? Brian Herbert Withun Excel Programming 2 January 25th 08 02:24 PM
cell value storage Leo Rod Excel Programming 2 August 30th 07 03:47 PM
Data Storage gregory.barrett Excel Discussion (Misc queries) 3 March 30th 06 10:23 PM
Variable Storage gti_jobert[_10_] Excel Programming 3 February 8th 06 11:28 AM


All times are GMT +1. The time now is 01:52 AM.

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"