mercredi 4 mars 2015

Unable to find keywords from a .csv file by using 'grep'


I am dumping datum into a csv file (my_datum_file.csv). The contents are all comma seperated, and I want to find the last instance of the 4th parameter (i.e. the last instance of datum regarding MX3, TMX, MSV, etc. where printed). The 5th parameter is a 'subclass' of the 4th parameter (ie TMX has 098 and 001). It is also important that the 7th parameter be "status" as opposed to "SVlts". Q: I want the 9th value (which is a period of time in minutes) to convert to hours. I would like to print this value out.


So from the terminal I wrote:



$ cat /directory/some_more_directory/my_datum_file.csv | grep TMX | grep 098 | grep status | awk -F ","'{print$9/60}'

The end result is nothing i.e. its as if I just pressed enter in the terminal after entering no command :/


Eventually I will embed this into a bash script.



Aucun commentaire:

Enregistrer un commentaire