9 replies to this topic

[ramesh0123]

I have a folder that contains 50 text files ,i require a program that can read these text files and convert them into tables,i want the primary key to be the name of the text file.
//sample contents of my 1.txt file is as follows
atro
astrology
king
moon
monkey
seven
skin
All the text file contain the information in the same format

[Kami-]

ramesh0123, on 25 February 2013 - 10:26, said:

I have a folder that contains 50 text files ,i require a program that can read these text files and convert them into tables,i want the primary key to be the name of the text file.
<snip>
All the text file contain the information in the same format

So you want 50 files converting into 50 tables, with a primary key bein the name of the file? eh? *headsplodes*

[Kalint]

red rum... Red Rum... RED RUM... RED RUM! RED RUM! RED RUM! RED RUM!

[Haggis]

yeah i am lost too

If you had one table with the text files name as the primary key

but if you had a table for each text file the primary key could not be the name of the text file as the primary key has to be unique

[tim_s]

Using a VARCHAR as a primary key would be a bad idea.

[Kami-]

I call TROLL!

[+Asik]

So you require someone to do your homework? Good luck with that.

[tim_s]

Create the table + bash = 10 minutes top but why would you do this?

[Kalint]

Dr_Asik, on 26 February 2013 - 17:51, said:

So you require someone to do your homework? Good luck with that.

I wouldn't believe a teacher would assign such a weird assignment like this.

[Hardcore Til I Die]

The primary key has to be UNIQUE as it is what is used to reference a record in a table.

So if your file (1.txt) contained:

atro
astrology
king
moon
monkey
seven
skin

Then your table would not be able to use the file name as the primary key for each of those records because the file name doesn't change; it will always be 1.txt. Each of those seven records must have a unique primary key.