Question: #Write a piped command using head , tail , sort , cut , and sed to return the date of the latest event in the

#Write a piped command using head, tail, sort, cut, and sed to return the date of the latest event in the file in yyyy/mm/dd format

Input file:

date time protocol ip-address port packet-size

2018-01-01 19:27:19 TCP 11.101.6.64 22 44

2018-04-17 01:35:12 UDP 10.101.7.69 2135 83

2018-05-05 04:26:05 UDP 11.101.6.65 2160 104

2018-08-20 15:43:16 TCP 10.101.7.64 22 113

2018-02-10 02:28:02 UDP 11.101.6.65 2089 68

2018-03-22 00:05:32 TCP 9.101.7.65 23 92

2018-04-24 19:32:47 TCP 9.100.8.65 22 93

2018-05-19 01:22:06 TCP 10.100.7.64 2107 29

2018-04-13 03:51:33 TCP 9.102.8.64 22 32

2018-08-16 21:02:36 UDP 11.100.8.65 2190 17

2018-06-27 00:44:54 UDP 11.101.6.65 2109 73

2018-01-08 07:39:00 TCP 10.101.8.65 22 74

2018-01-22 07:08:54 UDP 9.101.7.65 2165 27

2018-01-11 07:17:44 TCP 11.101.6.65 22 110

2018-01-10 13:14:41 TCP 10.101.7.64 22 89

2018-08-23 13:47:24 UDP 11.100.6.65 2187 93

2018-08-17 06:29:35 TCP 11.101.6.65 2114 66

2018-11-23 02:22:22 UDP 9.100.7.64 2142 118

2018-09-22 22:06:47 TCP 11.101.6.65 22 9

2018-04-04 09:41:43 UDP 9.102.7.64 2116 34

Output expected:

2018/11/23

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Task 01 (5 points) Write an piped command using cat, grep, and cut to read the provided data file, named lab0201.csv, and print the Name field from each line where the section is online Input file...

Hello, how would I Write a piped command using head, tail, sort, cut, and sed to return the date of the latest event in the file in yyyy/mm/dd format? Here is the Input file (lab0202.csv): date time...

Task 0 3 ( 1 0 points ) Write a piped command using tail, cut, sort, uniq, and wc to read the provided data file and print the number of unique students ( Name ) . Task 0 4 ( 1 0 points ) Write a...

Name,Final Grade,Section Andrew,95,online Brandon,100,online Chelsey,100,onsite Deborah,72,online Eric,65,online Frank,88,onsite Shaun,91,onsite Ninette,82,online Nguyen,80,onsite...

Task 04 (20 points) Write a piped command using grep and cut to read the provided data file, find the entries that use UDP protocol to transmit packets less than 100 bytes, and print the port number...

Write a piped command using grep, sort, uniq, tail, wc, and cut to read the provided data file and return the number of unique IP addresses that match the following criteria: IP address begins with...

#Write a piped command using grep , sort , uniq , tail , wc , and cut to read the provided data file and return the number of unique entries that match the following criteria: IP address begins with...

UNIX: The data file is comprised of a header, followed by lines containing firewall events. You can view the head of the file with the following command; cat firewall.log | head OUTPUT OF COMMAND:...

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Which of the following best describes mutual agency? Forming a partnership increases the base of management talent Each partner reports his/her share of partnership income on his/her personal tax...

If X and Y have joint density fX,Y(x, y) - 8xy on the triangle 0

Accountants face ethical dilemmas when a senior auditor Blank _ _ _ _ _ _ . Multiple select question. accepts tickets to a baseball game from an audit client decides which staff assistant will work...

Show the complete solution, diagrams (flows and labels) and assumptions made. The refrigerator that uses R-134a is located in a 20C room. Consider the cycle to be ideal, except that the compressor is...

Explain the purpose of the Project Charter and its relationship to Management Approval for a Project.

What is Change Control and how does it operate?

How do Data Requirements relate to Functional Requirements?