Inserting data into MYSQL from a TEXT FILE (not in CSV format)

I am a novice to PHP and MYSQL, I have been asked to create a new database on MYSQL, I have problem with the data, right now I am in the process of understanding the data, but the data is in text format and I guess separated by spaces, it is not comma delimited and each record is divided into 4 lines. So how should my approach be towards creating the database and the reading the data?

And do I have to write any script to read the data line by line and extract what I want and if so could any experts help me out with this.