I have the following lines in a csv file
server1,server2,6,0,0,100
server1,server2,6,0,0,0
server1,server4,8,9,5,98
server1,server5,8,9,5,100
server1,server6,1,29,8,0
server1,server4,1,29,8,56
etc..
now i only need the unique data of column 2 where column 6 is the numner 0
in a seperate file.
so server 2 and server 4 are double but has a 0, and a 100 or a 56, as column 6 so that shouldn't be in the new file
however server6 should be noted in the new file, only column 2 needs te be in te new file
i'm puzzling all day with all kind of examples with arrays and sorting scripts found in google and combining them
to get what i need, my last resort is here, does anyone have an idea ?
Thx for the effort
server1,server2,6,0,0,100
server1,server2,6,0,0,0
server1,server4,8,9,5,98
server1,server5,8,9,5,100
server1,server6,1,29,8,0
server1,server4,1,29,8,56
etc..
now i only need the unique data of column 2 where column 6 is the numner 0
in a seperate file.
so server 2 and server 4 are double but has a 0, and a 100 or a 56, as column 6 so that shouldn't be in the new file
however server6 should be noted in the new file, only column 2 needs te be in te new file
i'm puzzling all day with all kind of examples with arrays and sorting scripts found in google and combining them
to get what i need, my last resort is here, does anyone have an idea ?
Thx for the effort