Awk Question

FireBall
FireBall used Ask the Experts™
on
Dear friends i need an awk script and i hope you help me , that show me the only this output with - delimiter

05/Apr/2016:21:20:12 +0300 - 88.246.147.220 - PowerDance64kaac  - iPower/46 CFNetwork/758.3.15 Darwin/15.4.0

88.246.147.220 - - [05/Apr/2016:21:20:12 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 80014 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 2
81.215.197.1 - - [05/Apr/2016:21:20:16 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 10682215 "http://www.powerapp.com.tr/radio/powerTurkEfsane" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 664
178.240.139.199 - - [05/Apr/2016:21:20:21 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 160814 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 74
176.55.64.181 - - [05/Apr/2016:21:20:24 +0300] "GET /PowerDance128kaac HTTP/1.1" 200 6535357 "-" "Lavf/56.15.102" 420
85.102.21.21 - - [05/Apr/2016:21:20:26 +0300] "GET /Efsane64kaac HTTP/1.1" 200 94014 "-" "iPower/29 CFNetwork/758.2.8 Darwin/15.0.0" 4
212.156.114.102 - - [05/Apr/2016:21:20:33 +0300] "GET /Efsane64kaac HTTP/1.0" 200 216526 "-" "iPower/46 CFNetwork/758.2.8 Darwin/15.0.0" 81
176.54.97.207 - - [05/Apr/2016:21:20:33 +0300] "GET /Efsane64kaac HTTP/1.1" 200 94014 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 4
188.57.143.182 - - [05/Apr/2016:21:20:33 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 2988526 "-" "iPower/46 CFNetwork/711.1.12 Darwin/14.0.0" 411
176.55.36.30 - - [05/Apr/2016:21:20:35 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 145858 "-" "Lavf/56.15.102" 11
178.241.151.248 - - [05/Apr/2016:21:20:35 +0300] "GET /Efsane64kaac HTTP/1.1" 200 15292414 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 1818
88.234.229.34 - - [05/Apr/2016:21:20:36 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 9372435 "http://smartworld.powergroup.com.tr/?platform=lgtv" "Mozilla/5.0 (Web0S; Linux/SmartTV) AppleWebKit/538.2 (KHTML, like Gecko) Large Screen Safari/538.2 LG Browser/7.00.00(LGE; 43UF6807-ZA; 04.20.70; 1; DTV_W15A); webOS.TV-2015; LG NetCast.TV-2013 Compatible (LGE, 43UF6807-ZA, wireless)" 582
85.102.21.21 - - [05/Apr/2016:21:20:44 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 77214 "-" "iPower/29 CFNetwork/758.2.8 Darwin/15.0.0" 3
79.236.144.228 - - [05/Apr/2016:21:20:45 +0300] "GET /PowerDance128kmpeg HTTP/1.1" 200 154215 "http://www.powerapp.com.tr/radio/powerDance" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 6
88.230.118.233 - - [05/Apr/2016:21:20:45 +0300] "GET /PowerDance128kmpeg HTTP/1.1" 200 102415 "http://www.powerapp.com.tr/radio/powerDance" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 3
37.154.174.222 - - [05/Apr/2016:21:20:46 +0300] "GET /Efsane64kaac HTTP/1.1" 200 120656 "-" "Lavf/56.15.102" 7
88.249.69.181 - - [05/Apr/2016:21:20:54 +0300] "GET /PowerDance128kmpeg HTTP/1.1" 200 15916815 "http://www.powerapp.com.tr/radio/powerDance" "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 991
188.58.5.5 - - [05/Apr/2016:21:20:58 +0300] "GET /Efsane128kaac HTTP/1.1" 200 2767434 "-" "Lavf/56.15.102" 195
85.109.252.116 - - [05/Apr/2016:21:20:59 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 94054 "-" "Lavf/56.15.102" 4
188.57.53.238 - - [05/Apr/2016:21:21:01 +0300] "GET /Efsane64kaac HTTP/1.1" 200 243934 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 84
178.241.112.57 - - [05/Apr/2016:21:21:02 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 793422 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 151
188.58.52.150 - - [05/Apr/2016:21:21:02 +0300] "GET /Efsane96kaac HTTP/1.1" 200 388781 "-" "Lavf/56.15.102" 68
5.46.106.251 - - [05/Apr/2016:21:21:06 +0300] "GET /Efsane64kaac HTTP/1.1" 200 88414 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 3
92.45.156.190 - - [05/Apr/2016:21:21:10 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 1639615 "http://www.powerapp.com.tr/radio/powerTurkEfsane" "Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 98
195.142.178.208 - - [05/Apr/2016:21:21:13 +0300] "GET /Efsane64kaac HTTP/1.1" 200 94014 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 4
176.55.50.69 - - [05/Apr/2016:21:21:22 +0300] "GET /Efsane64kaac HTTP/1.1" 200 125046 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 28
5.46.203.249 - - [05/Apr/2016:21:21:24 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 3374214 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 395
178.240.6.70 - - [05/Apr/2016:21:21:28 +0300] "GET /Efsane64kaac HTTP/1.1" 200 2224222 "-" "iPower/33 CFNetwork/758.1.6 Darwin/15.0.0" 321
208.94.3.51 - - [05/Apr/2016:21:21:44 +0300] "GET /PowerDance96kaac HTTP/1.0" 200 709710 "-" "Lavf/55.19.104" 93
88.226.135.223 - - [05/Apr/2016:21:21:48 +0300] "GET /PowerDance128kaac HTTP/1.1" 200 1841214 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 108
176.55.82.236 - - [05/Apr/2016:21:21:48 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 943503 "-" "Lavf/56.15.102" 167
95.85.96.105 - - [05/Apr/2016:21:22:03 +0300] "GET /PowerDance96kaac HTTP/1.1" 200 984414 "-" "Lavf/55.19.104" 74
178.240.161.249 - - [05/Apr/2016:21:22:03 +0300] "GET /Efsane64kaac HTTP/1.1" 200 1510222 "-" "iPower/44 CFNetwork/672.1.15 Darwin/14.0.0" 235
178.241.124.124 - - [05/Apr/2016:21:22:07 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 153622 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 74
95.13.113.112 - - [05/Apr/2016:21:22:11 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 1117415 "http://www.powerapp.com.tr/radio/powerTurkEfsane" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 66
37.154.134.146 - - [05/Apr/2016:21:22:17 +0300] "GET /Efsane64kaac HTTP/1.1" 200 4109214 "-" "iPower/44 CFNetwork/672.1.15 Darwin/14.0.0" 484
88.231.2.29 - - [05/Apr/2016:21:22:18 +0300] "GET /PowerDance128kmpeg HTTP/1.1" 200 37665815 "http://www.powerapp.com.tr/radio/powerDance" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 2351
80.112.31.222 - - [05/Apr/2016:21:22:20 +0300] "GET /Efsane64kaac HTTP/1.1" 200 91214 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 4
88.226.135.223 - - [05/Apr/2016:21:22:24 +0300] "GET /Efsane128kaac HTTP/1.1" 200 561614 "-" "iPower/46 CFNetwork/758.3.15 Darwin/15.4.0" 31
178.241.193.125 - - [05/Apr/2016:21:22:27 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 794726 "-" "iPower/44 CFNetwork/758.2.8 Darwin/15.0.0" 150
188.57.140.135 - - [05/Apr/2016:21:22:29 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 397181 "-" "Lavf/56.15.102" 102
176.54.69.225 - - [05/Apr/2016:21:22:29 +0300] "GET /Efsane64kaac HTTP/1.1" 200 178014 "-" "iPower/33 CFNetwork/758.3.15 Darwin/15.4.0" 14
178.241.193.125 - - [05/Apr/2016:21:22:31 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 143822 "-" "iPower/44 CFNetwork/758.2.8 Darwin/15.0.0" 72
176.238.9.100 - - [05/Apr/2016:21:22:36 +0300] "GET /Efsane64kaac HTTP/1.1" 200 110814 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 6
188.57.173.85 - - [05/Apr/2016:21:22:39 +0300] "GET /Efsane64kaac HTTP/1.1" 200 240422 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 84
81.215.81.108 - - [05/Apr/2016:21:22:49 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 211615 "-" "Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 YaBrowser/16.3.0.6796 Yowser/2.5 Safari/537.36" 9
188.57.8.117 - - [05/Apr/2016:21:22:50 +0300] "GET /PowerDance64kaac HTTP/1.1" 200 153574 "-" "iPower/44 CFNetwork/758.2.8 Darwin/15.0.0" 73
188.58.19.121 - - [05/Apr/2016:21:22:51 +0300] "GET /Efsane128kaac HTTP/1.1" 200 681326 "-" "iPower/44 CFNetwork/758.3.15 Darwin/15.4.0" 70
95.8.113.104 - - [05/Apr/2016:21:22:53 +0300] "GET /Efsane64kaac HTTP/1.1" 200 14170534 "-" "Lavf/56.15.102" 1683
176.41.121.147 - - [05/Apr/2016:21:23:11 +0300] "GET /Efsane128kaac HTTP/1.1" 200 179414 "-" "iPower/46 CFNetwork/758.0.2 Darwin/15.0.0" 39
208.94.3.51 - - [05/Apr/2016:21:23:18 +0300] "GET /PowerDance96kaac HTTP/1.0" 200 450710 "-" "Lavf/55.19.104" 74
78.163.2.171 - - [05/Apr/2016:21:23:20 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 241015 "http://www.powerapp.com.tr/radio/powerTurkEfsane" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36" 11
88.240.75.32 - - [05/Apr/2016:21:23:21 +0300] "GET /Efsane128kmpeg HTTP/1.1" 200 333415 "http://www.powerapp.com.tr/radio/powerTurkEfsane" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0" 17

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Topic Advisor
Most Valuable Expert 2016
Commented:
Something like this:

awk '{print $4 " " $5 " - " $1 " - " $7 " - " $12 " " $13 " " $14}' <yourfile.txt>

Author

Commented:
Thank you that bring me to solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial