Reply
Sun 11 Nov, 2012 06:57 pm
Hi, I have a question abot reading and outputting infromation in a search.
I have a spreadsheet (in txt form seperated by tabs) that can be opend to a spreadsheet. If opend as a spreadsheet it would have, say, 12 columns of information
(i.e.) First Name, Middle Name, Surname, address, Age, Gender... and so on.
I was hoping to design a program that would allow me to 1) choose which peramater(s) to search from 2) enter in my search term 3) have the full information listed om a table for all results
So if I choose to search by first name and put in 'Joe' all 'Joe' will come up followed by all other peramiters. If I search by surname 'Smith' it will come up with:
Alvin B Smith...
Bob J Smith....
Or I could choose both to narrow the results.
What I'm stuck on is reading the information from a txt file (the database is already created so no need for inputting) and outputting that information in a table in proper order.
Any suggestions welcomed!
Thanks folks! :-)
@JKC,
Search in which program? E. g. are you trying to do a search directly in Excel? If so, then I think you'd need to use VB code.
For larger databases, where you'd use SQL code, you would likely query using the LIKE function, e. g.
SELECT * FROM names
WHERE first_name like 'Joe%';
@jespah,
I was hoping to do this in Javascript so I could eventually integrate it into a website. At the moment I have the info in a txt file seperated by tabs.
@JKC,
Huh. Well, you're beyond my skill set, I'm afraid. Sorry.
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace