Good evening.

I have a text file containing over 1000 lines of data in the following format

|2013-07-29 20:18:00|4.28e-07

I wish to separate this data so I have the date - time - float number and the other element e-07 (which changes through out the file)

The file contains data relating to every minute over several months so filtering using the zl object doesn't really work

I have been experimenting with the regexp and other uses of the zl object, alas i have had no joy.

Any help would be greatly appriciated. I am more than happy to send a small version of my text file if anyone needs it to understand any more, however it really is as simple as

|2013-07-29 20:18:00|4.28e-07 |2013-07-29 20:19:00|5.34e-07 |2013-07-29 20:20:00|4.55e-07 ..... |2013-08-29 20:15:00|3.56e-07 and so on

Regards

Lloyd