reading a file

[newjoinee]

Hi, I have a file something like this: which is the input to my script

1:
this is a line

2:
this is another line

3:
this is the third line.



Im trying to read this file, split and use the numbers and text as separate fields.



Im doing this to insert these fields as values in an SQL table using mysql.

However im not sure as to how to proceed with it,


Kindly help


Thanks

[newjoinee]

I found the answer


Thanks

[eWish]

What was the answer?

[Icecrack]

it will be a good thing to put the answer up as it will help others find a solution to the problem you had.

Thanks

Charlie

[KevinADC]

the answer is:

open(FILE, 'filename');
@lines = <FILE>;
chomp @lines;
close FILE;