Need pattern Extract Post: 302904811

Sponsored Content

Top Forums Shell Programming and Scripting Need pattern Extract Post 302904811 by ilugopal on Friday 6th of June 2014 03:22:19 PM

06-06-2014

Registered User

Need pattern Extract

Code:

2014-05-31-18.22.18.500158-240 E11115478A502      LEVEL: Info
PID     : 25100668             TID  : 73282       PROC : db2sysc 0
INSTANCE: udbin001             NODE : 000         DB   : 
APPHDL  : 0-18345              APPID: *LOCAL.udbin001.140531200018
AUTHID  : udbin001
EDUID   : 73282                EDUNAME: db2agent (IBGPM01P) 0
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:312
MESSAGE : Actual size of backup in bytes:
DATA #1 : unsigned integer, 8 bytes
175023153152

2014-06-01-11.58.08.193212-240 E11131215A503      LEVEL: Info
PID     : 25100668             TID  : 66744       PROC : db2sysc 0
INSTANCE: udbin001             NODE : 000         DB   : 
APPHDL  : 0-13715              APPID: *LOCAL.udbin001.140601130013
AUTHID  : udbin001
EDUID   : 66744                EDUNAME: db2agent (IBGPM01P) 0
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:312
MESSAGE : Actual size of backup in bytes:
DATA #1 : unsigned integer, 8 bytes
3378060292096

2014-06-02-18.21.43.195977-240 E11542845A501      LEVEL: Info
PID     : 25100668             TID  : 74822       PROC : db2sysc 0
INSTANCE: udbin001             NODE : 000         DB   : 
APPHDL  : 0-41425              APPID: *LOCAL.udbin001.140602200006
AUTHID  : udbin001
EDUID   : 74822                EDUNAME: db2agent (IBGPM01P) 0
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:312
MESSAGE : Actual size of backup in bytes:
DATA #1 : unsigned integer, 8 bytes
40982392832

I wish to extract the following details from above file content
time

Code:

2014-05-31-18.22,175023153152
2014-06-01-11.58,3378060292096
2014-06-02-18.21,40982392832

I use cat <filename> | grep -ip -w "Actual size of backup in bytes:" to extract the above details from a main diaglog. However i would need the above details . I'm ok with any solution based on awk, sed.

Last edited by Franklin52; 06-06-2014 at 04:55 PM.. Reason: Please use code tags

ilugopal

View Public Profile for ilugopal

Find all posts by ilugopal

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract the Pattern

Hello All, can anyone help me out in extracting the pattern from a file... The Input file is: NFS B.11.11 ONC/NFS; Network-FileSystem,InformationServices,Utilities|123 NParProvider B.11.11.01.04.01.01 nPartition Provider|456 NPartition A.01.02 Enhanced NPartition Commands/789...

2. Shell Programming and Scripting

Extract if pattern matches

Hi All, I have an input below. I tried to use the awk below but it seems that it ;s not working. Can anybody help ? My concept here is to find the 2nd field of the last occurrence of such pattern " ** XXX ccc ccc cc cc ccc 2007 " . In this case, the 2nd field is " XXX ". With this "XXX" term...

3. Shell Programming and Scripting

pattern extract

Hi I have a pattern like : SYSTEM_NAME-232-S7-200810060949.LOG Here I need to extract system name and the timestamp and also the numeric number after "-S" i.e 7 here . I am not very sure of whether I should use sed / awk for this ?:confused: Thanks, Priya.

4. Shell Programming and Scripting

extract based on pattern

I have a mail log file and I want to extract some lines belonging to one domain. For example Input File: Dec 12 03:15:28 postfix/smtpd: 3F481EB0295: client=unknown, sasl_method=PLAIN, sasl_username=abcd@xyz.com Dec 12 03:22:08 postfix/smtpd: 60B56EE001D: client=5ad9b9ba.com,...

5. Shell Programming and Scripting

sed: Find start of pattern and extract text to end of line, including the pattern

This is my first post, please be nice. I have tried to google and read different tutorials. The task at hand is: Input file input.txt (example) abc123defhij-E-1234jslo 456ujs-W-abXjklp From this file the task is to grep the -E- and -W- strings that are unique and write a new file...

6. Shell Programming and Scripting

Extract pattern before two newlines

Hi All, My file looks like this: 1 2 3 3 4 5 6 7 8 8 7 6 3 4 5 3 6 7 3 4 5 1 2 4 3 4 6 2 4 6 As you can see there are two newlines after the next pattern of numbers begin.

7. Shell Programming and Scripting

Search for a pattern,extract value(s) from next line, extract lines having those extracted value(s)

I have hundreds of files to process. In each file I need to look for a pattern then extract value(s) from next line and then search for value(s) selected from point (2) in the same file at a specific position. HEADER ELECTRON TRANSPORT 18-MAR-98 1A7V TITLE CYTOCHROME...

8. Shell Programming and Scripting

Extract pattern from text

Hi all, I got a txt here and I need to extract all D 8888 44 and D 8888 43 + next field =",g("en")];f._sn&&(f._sn= "og."+f._sn);for(var n in f)l.push("&"),l.push(g(n)),l.push("="),l.push(g(f));l.push("&emsg=");l.push(g(d.name+":"+d.message));var m=l.join("");Ea(m)&&(m=m.substr(0,2E3));c=m;var...

9. UNIX for Beginners Questions & Answers

Help with pattern match and Extract

Hi All, I am having a file like below . Basically when SB comes in the text with B. I have to take the word till SB. When there only B I should take take till B. Tried for cut it by demilter but not able to build the logic SB- CD B_RESTO SB_RESTO CRYSTALS BOILERS -->There SB and B so I...

10. Shell Programming and Scripting

Extract whole word preceding a specific character pattern with first occurence of the pattern

Hello. Here is a file contents : declare -Ax NEW_FORCE_IGNORE_ARRAY=(="§" ="§" ="§" ="§" ="§" .................. ="§"Here is a pattern =I want to extract 'NEW_FORCE_IGNORE_ARRAY' which is the whole word before the first occurrence of pattern '=' Is there a better solution than mine :...

LEARN ABOUT CENTOS

grub2-fstest

GRUB-FSTEST(3)						     Library Functions Manual						    GRUB-FSTEST(3)

NAME

       grub-fstest -- Debug tool for GRUB's filesystem driver.

SYNOPSIS

       grub-fstest [-c | --diskcount=NUM] [-C | --crypto]
		    [-d | --debug=STRING] [-K | --zfs-key=FILE|prompt]
		    [-n | --length=NUM] [-r | --root=DEVICE_NAME]
		    [-s | --skip=NUM] [-u | --uncompress] [-v | --verbose]
		    IMAGE_PATH <blocklist FILE | cat FILE |
		    cmp FILE LOCAL | cp FILE LOCAL | crc FILE |
		    hex FILE | ls PATH | xnu_uuid DEVICE>

DESCRIPTION

       grub-fstest is a tool for testing GRUB's filesystem drivers.  You should not normally need to run this program.

OPTIONS

       --diskcount=NUM
	      Specify the number of input files.

       --crypto
	      Mount cryptographic devices.

       --debug=STRING
	      Set debug environment variable.

       --zfs-key=FILE|prompt
	      Load ZFS cryptographic key.

       --length=NUM
	      Handle NUM bytes in output file.

       --root=DEVICE_NAME
	      Set root device.

       --skip=NUM
	      Skip NUM bytes from output file.

       --uncompress
	      Uncompress data.

       --verbose
	      Print verbose messages.

COMMANDS

       blocklist FILE
	      Display block list of FILE.

       cat FILE
	      Display FILE on standard output.

       cmp FILE LOCAL
	      Compare FILE with local file LOCAL.

       cp FILE LOCAL
	      Copy FILE to local file LOCAL.

       crc FILE
	      Display the CRC-32 checksum of FILE.

       hex FILE
	      Display contents of FILE in hexidecimal.

       ls PATH
	      List files at PATH.

       xnu_uuid DEVICE
	      Display the XNU UUID of DEVICE.

SEE ALSO

       info grub

								  Wed Feb 26 2014						    GRUB-FSTEST(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extract the Pattern

Discussion started by: aajan

2. Shell Programming and Scripting

Extract if pattern matches

Discussion started by: Raynon

3. Shell Programming and Scripting

pattern extract

Discussion started by: priyam

4. Shell Programming and Scripting

extract based on pattern

Discussion started by: Bijayant Kumar