Lloyd Starr

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

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

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)

|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

parsefilter-text-files

I also have the data in am XMl file but i cannot get my head around parsing an XMl file.

Again i can provide either text or XMl files if need be

This has been resolved now with massive thanks to Robert Alexander.

It is possible to sort/filter the .txt files by importing them into microsoft excel.

Parse/Filter Text Files