reading from file

Hi,
i am having one lengthy text file, in that

* for each record is having 26 fields , field seperated by ","
* each line is ended with "%"
* record sze is vary

so now i am going to read that file content after expolde that, through code i need to insert that into mysql table.

how can i read one line? that is upto "%" is one line

plz give me a idea,


Thanks
shyami

 

Could you post maybe 3~ lines so we can see the format exactly as is (it makes it easier )