awk parsing file Post: 303011303

Sponsored Content

Top Forums Shell Programming and Scripting awk parsing file Post 303011303 by shunya on Tuesday 16th of January 2018 10:24:39 AM

01-16-2018

Registered User

Actually, I don't need ID field ( ID Field has hex values like FAD00, BAC76) I don't need those. I want only LOC ID which I can provide as a variable input as well ( awk -v LOC="ssfad_fs" . Also don't require LOC, Total Size, Comp Size fields in the output.

Regarding some of the seconds are decremented because when I generate file sometimes there is 1 second difference. Actually the I/P file I provided and O/P are from different files. That is why there is mismatch. Sorry for the confusion. Here is the O/P from same I/P file.

Code:

Loc ID	 Img Name               Ver.   Time                    Complete Time
ssfad_fs TINT_PAP_1516048511     0    Mon Jan 15 20:35:13 2018 NA
ssfad_fs sfad_jpg                1    Mon Jan 15 16:24:02 2018 Wed Jan 17 16:24:02 2018
ssfad_fs sfad_jpg                2    Mon Jan 15 12:24:03 2018 Wed Jan 17 12:24:02 2018
ssfad_fs sfad_jpg                3    Mon Jan 15 08:24:02 2018 Wed Jan 17 08:24:02 2018
ssfad_fs sfad_jpg                4    Mon Jan 15 04:24:02 2018 Wed Jan 17 04:24:02 2018
ssfad_fs sfad_jpg                5    Mon Jan 15 00:24:03 2018 Wed Jan 17 00:24:02 2018
ssfad_fs sfad_jpg                6    Sun Jan 14 20:24:03 2018 Tue Jan 16 20:24:02 2018
ssfad_fs sfad_jpg                7    Sun Jan 14 16:24:03 2018 Tue Jan 16 16:24:02 2018
ssfad_fs sfad_jpg                8    Sun Jan 14 12:24:02 2018 Tue Jan 16 12:24:02 2018
ssfad_fs sfad_jpg                9    Sun Jan 14 08:24:03 2018 Tue Jan 16 08:24:02 2018
ssfad_fs sfad_jpg               10    Sun Jan 14 04:24:02 2018 Tue Jan 16 04:24:01 2018
ssfad_fs sfad_jpg               11    Sun Jan 14 00:24:02 2018 Tue Jan 16 00:24:02 2018
ssfad_fs sfad_jpg               12    Tue Oct 10 21:00:47 2017 NA

shunya

View Public Profile for shunya

Find all posts by shunya

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing file through awk

hi, how can i achieve this in awk CON Controllers Department R abcuser usernamedesc1 R defuser usernamedesc2 R ...

2. Shell Programming and Scripting

AWK and Magic with file parsing

Hi, I have a input file like this TH2TH2867Y NOW33332106Yo You Baby TH2TH3867Y NOW33332106No Way Out TH2TH9867Y NOW33332106Can't find it TJ2TJ2872N WOW33332017sure thing alas TJ2TJ3872N WOW33332017the sky rocks TJ2TJ4872N WOW33332017nothing else matters TJ2TJ5872N WOW33332017you know...

3. Shell Programming and Scripting

awk and file parsing

4. Shell Programming and Scripting

Parsing a file (sed/awk?)

Hello people, newbie question. I'm trying to parse these type of file 1 "CAR " " C1 " " " 6 0 C1 2 "CAR " " O1A" " " 8 0 O1A 3 "CAR " " O1B" " " 8 -1 O1B 4 "CAR " " C2 " " " 6 0 C2 5 "CAR " " C3 " " " 6 ...

5. Shell Programming and Scripting

awk/sed for parsing file

Hi All, I have a log file like this E Mon Oct 06 00:17:08 2008 xxx2 cm:10614 fm_pi2_svc_iptv_purchase.c:149 1:pin_deferred_act:10601:11:169:1223245028:16 pi2_op_svc_iptv_purchase error <location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1...

6. UNIX for Advanced & Expert Users

Parsing through a file with awk/sed

I don't necessary have a problem, as I have a solution. It is just that there may be a better solution. GOAL: Part one: Parse data from a file using the "\" as a delimiter and extracting only the last delimiter. Part two: Parse same file and extract everything but the last delimited item. ...

7. Shell Programming and Scripting

Parsing a file with AWK

Input Group: Erecords: Copy: ADC R2: Replication volumes: Replication set: RSet 1 Replication size: 50.00GB SAN Info: 50.00GB DGC VRAID CX4-960 LUN 1040 (1040) 60,06,01,60,32,bb,21,00,84,a0,08,b1,da,ec,df,11...

8. Shell Programming and Scripting

Help in file parsing with awk

Hi, I have a data set as shown below: 09e757fd,22727,2012-03-01,text1,text2,to 3fd0cae7,310,2012-03-01,text3,text4,to 3fd0cae7,310,2012-03-01,text3,text5,to 3fd0cae7,311,2012-03-01,text7,text10,cc 3fd0cae7,311,2012-03-01,text7,text11,to 3fd0cae7,312,2012-03-01,text8,text15,to...

9. Shell Programming and Scripting

AWK? parsing /etc/passwd file.

Hello guys, please help me to make simple script for parsing passwd file. I have many passwd files from our servers, named server1.pass, server2.pass etc.. so for server in `ls *.pass` i need to print these rows: server1;root:!:0:0::/root:/usr/bin/ksh...

10. Shell Programming and Scripting

Parsing a file name with awk

I have a command to print out the top 5 most cpu intensive commands: ps aux --sort=-%cpu --no-headers I would like to make a printout containing only the parsed file name. So, I want to turn this: $ ps aux --sort=-%cpu --no-headers user 24883 4.3 1.7 2010436 131440 ? Sl ...

LEARN ABOUT OPENSOLARIS

ds.log

ds.log(4)							   File Formats 							 ds.log(4)

NAME

       ds.log - Availability Suite data services log file

DESCRIPTION

       The  /var/adm/ds.log file contains the Availability Suite data services command log. The administration commands log activities to the file
       in the format:

	 date time product: message

       Note that when the size of the log file exceeds 10 Mbytes, ds.log is renamed  /var/adm/ds.log.bak  and a new /var/adm/ds.log file  is  cre-
       ated.

       The ds.log fields are:

       date

	   The	date format is mmm nn, where mmm  is  the local three-character abbreviation for the month and nn is the day of the month on which
	   the event occurred.

       time

	   The time of the event, in hh:mm:ss format.

       product

	   A product code that identifies which component of the data services produced the event. The code is separated  from	the  message  that
	   follows by a colon (:) and a space.

       message

	   A  message  that  can extend over  more  than  one  line describing the event that occurred. The second or following lines are not pre-
	   fixed by  the  date, time, and product code strings.

EXAMPLES

       The example below shows sample ds.log file content:

	 Jan 25 05:26:17 ii: iiboot suspend cluster tag <none>
	 Jan 25 05:32:02 ii: iiboot resume cluster tag <none>
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigmaster
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/bigshadow
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/mstvxfs
	 Jan 25 05:32:04 sv: svboot: resume /dev/vx/rdsk/master01

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +---------------------+---------------------------------------------------------+
       |   ATTRIBUTE TYPE    |			   ATTRIBUTE VALUE		       |
       +---------------------+---------------------------------------------------------+
       |Architecture	     | x86						       |
       +---------------------+---------------------------------------------------------+
       |Availability	     | SUNWscmu 					       |
       +---------------------+---------------------------------------------------------+
       |Interface Stability  | Committed					       |
       +---------------------+---------------------------------------------------------+

SEE ALSO

       iiadm(1M), sndradm(1M), svadm(1M), attributes(5)

SunOS 5.11							    08 Jun 2007 							 ds.log(4)