How to obtain unique value of the same value with Unix command

I have a huge csv file I want to know the same source IP address and destination IP address unique value and how to convert my log timing format

"Date", "User Information", "Source IP", "Destination IP", "HTTP Status Code", "HTTP Method", "URL", "Receive byte", "Send byte" "[31/Jul/2018:21:11:55 +0900] ","ayw23","17.248.157.14","17.248.157.14","247","CONNECT","setup.iciwh.com:443","2938","600" 

So compare the use of awk?

cat file.csv| awk '$6 == $7' 

I like to get such output

2018/7/31 21:11 17.248.157.14 setup.iciwh.com:443 

submitted by /u/rockzers
[link] [comments]

Leave a Reply