samedi 12 mai 2018

Extract part of txt file

I have a very large txt file and I would like to extract specific columns of the txt file that start with a specific pattern to an xls file preferably. The data I would like to extract start with a track id number (i.e. Track ID=20). I would like to be able to read the track id number and then store some of the info given below and then do it again for the next track id etc.. I searched online and figured it should be possible using powershell on windows. Any help would be greatly appreciated.

Below the image is a small part of the txt. In this instance i want to keep the id number which is 13 and also the columns Z(mm) and KinE(MeV)

part of the txt file

Aucun commentaire:

Enregistrer un commentaire