Helo house,i have a data file named text.db and i want to retrieve the text stored in the data file and display the lines and filter. How can I go about this.

Using what language? How is the data arranged? Is it a table or just some lines of information?

Using Java,am trying to retrieve the lines of text and display them one after the other on a GUI.
Its arranged according to the format below
query:options:correct-response-to-query

Danyl:

Using Java,am trying to retrieve the lines of text and display them one after the other on a GUI.
Its arranged according to the format below
query:options:correct-response-to-query

Well displaying them I shall leave for you to handle. Lets work through the format of the file.
You have a query  and then option separated by :
You the have : and then another string 'correct response to query'

Just to be sure, an example would be:
SELECT * FROM 'blog_posts' WHERE`ID`=45:LIMIT 0,30:Yes the posts exists

Am i correct? If No then pls provide an example. The reason why I want an example is because the easiest and most reasonable way to tackle this is with a regular expression. I can provide that for you.

Another way would be to use the split function in the String class.

The way it works is, you take a String and split with a delimiter. The result of the split gets stored in an array.

For instance:
String line = "query:options:correct-response-to-query";
String[] values = line.split(":+");

Here are the elements of values:
values[0] = query
values[1] = options
values[2] = correct-response-to-query

Note that I assume you know how to read from a file. If you cant then this would be of help.
Scanner reader = new  Scanner(new FileReader("filename.db")); //open the file and get ready to read it.
while(reader.hasNextLine()){ //loop while you still have a line in the file.
     String line = reader.nextLine(); //read in a line into the string
   
    // process each line here
}

Thanx fayimora 4ur response,i tried to use the Scanner class readline to display a text.txt file,n display it on a text area component on a simple GUI. But i want to deal with a .db file with d folowing format;
1. what is your age?:23~22~32~40:40.
2. What is ur birth year?:1980~1981~1982:1981.
I want to retrieve the questions,store them in a String object and d options and answers into an int primitive type and manipulate them on the GUI,I Can handle the GUI bt the retrieval in order is the issue am trying to solve. Thanx

Ok cool so use what i have written above. As long as you know the format of the file, the extension doesn't stop you from accessing it like any other file.However, you would add some extra bits . . . .
Remember that values[1] = options;

However, 'options' also contain something else that you need to split up,  Try writing just a line of code that gives you an array of options, so if you have

String [] options;
options[0] = 23;
options[1]  = 22;
options[2] = 32;
options[3] = 40;

and then you can use your values there.
The previous code i wrote would be of help,  Try it out!

Thnx alot fayimora,4 your responses.,what about the delimiter "~" i hope it doesnt .the code doesnt have to be changed due to that

Yes your delimiter would now be '~', however if you noticed I used the wildcard '+'. It just means 1 or more. So it takes care of a situation where you have more than 1 '~'. FOr instance '23~24~~27'. Let me know if you have any problems.

It worked out,when i retrieved the options with the split(),i had to further split the options into As,Bs and Cs. String[] options=lines[1].split("~+"; (where line[1] is the array location for the options retrieved frm the lines in the text file) to remove the delimiter and extract the options.
Options[0] is the array location for options A,
options[1] for Bs.
Here is the output from the console:
A.ayo
A.1985
A.20 for the As.
I want to split the As into single options, i tried to use the split("\n" function bt it didnt work how do i work this out if its possible.

I don't think i ununderstand wat you want to do. What As are you talk about?

From d text file file.db
the text line is
1. What is ur age?:A.23~B.24~C.25:A.22
So am tlkn abt the A(s) options. For each line of text.

Well split it with .

Thanx alot i got it,

Anytime

I have openned a .db file(s) using common notepad. You can try it. it works on win 7