Database?

railroader · Post by **railroader** » Thu Mar 08, 2007 6:42 am

I have made a list of one line addresses. Is it possible to create a searchable database with textpad? I have in mind a booking system for taxi firm.

talleyrand · Post by **talleyrand** » Thu Mar 08, 2007 3:44 pm

Database? No. A searchable text document, you bet.

TextPad might be a great way to write the program that would allow you make a booking system for a taxi firm but I don't see how it'd be the booking system.

railroader · Post by **railroader** » Fri Mar 09, 2007 7:40 pm

I have exactly the right ideas to do it, but I cant write the code. If there was an offer of help?

railroader · Post by **railroader** » Sat Mar 10, 2007 8:10 am

How much do you have to pay someone? can you do it by distance? Offering?

Jon Summers · Post by **Jon Summers** » Mon Mar 12, 2007 5:51 pm

Convert each address line to comma-separated values (CSV), then import the text file into Excel or another spreadsheet.
Excel provides column searching and ordering.

railroader · Post by **railroader** » Wed Mar 14, 2007 12:10 pm

How do you convert to comma seperated values?

vhdeskchris · Post by **vhdeskchris** » Wed Mar 14, 2007 2:07 pm

You can actually... It can't do relational but for basic flat record storage it can't be beaten.

you need for a database:-

1. A way to identify columns (explicit order tab separated)
2. A way to identify rows (line number)
3. A way to search for data in particular rows (F5)
4. A way to sort (Ctrl+A, F9!)

A booking system would probably be better done in Access or even better something more robust...

railroader · Post by **railroader** » Fri Mar 16, 2007 6:01 pm

You can actually what? My question was "how do you convert to comma seperated values"

What is something more robust?

mp · Post by mp » Fri Mar 16, 2007 6:39 pm

Hey railroader. I don't mean to be rude but have you tried to do any research on your own rather than continually asking for the hand feeding? Most folks want to lend a hand but most folks are really busy doing their own work too.

To understand csv file and databases one only has to exploit the wealth of info on the net, but in the interests of being helpful here are some links to get you started:

Databases

CSV (Comma Separated Values) files

To appreciate why CSV files are useful (and a common denominator between database applications) see --

Parsing

Cheers,

Michael.

railroader · Post by **railroader** » Sat Mar 17, 2007 1:16 am

Sorry I thought this forum was all about swapping information and I did offer to pay so thats hardly handfeeding. But thanks anyhow.

mp · Post by mp » Sat Mar 17, 2007 1:21 am

Did you read the info at the links (and subsequent links)?

derek325 · Post by **derek325** » Sun Mar 18, 2007 9:54 pm

Railroader, this forum IS about swapping information about certain topic: about TextPad text editor. It IS NOT about swapping information about life, Universe and everything.

What you ask are questions not related to the topic of this forum. I believe that myself and a few other guys politely indicated direction you should be following. Another good move would be to find an appropriate forum, NOT this one. On the Internet there are hundreds thousands of forums dedicated to all possible topics. This one is about TextPad, a text editor. Wrong place.

Jon Summers · Post by **Jon Summers** » Mon Mar 19, 2007 3:50 pm

"How do you convert to comma seperated values?"

Have you looked at a comma separated value (CSV) file? Use Excel to create a simple table, then 'Save As' csv. Open the CSV file with your favourite text editor.

talleyrand · Post by **talleyrand** » Mon Mar 19, 2007 4:12 pm

Ewwww no. I do a good deal of work with data and let me just say Excel is a horrible tool for creating CSVs. Fine tool for viewing data, fine tool for doing spreadsheet activities but the conversion out of native format to CSV is utter crap.

railroader · Post by **railroader** » Tue Mar 20, 2007 1:02 pm

Derek "how do you convert to comma seperated values" is not about life and the universe and everything- it is about code that is written with textpad. I would prefer not to go on but there have been further replies past yours, thanks.

Community

Database?

Database?

Simple DB

Simple Database