Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need pattern Extract

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need pattern Extract
# 1  
Old 06-06-2014
Blade 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
# 2  
Old 06-06-2014
Code:
awk '{printf("%s.%s,%s\n", $1,$2,$NF)}' FS="." RS="" file

This User Gave Thanks to Aia For This Post:
ilugopal
# 3  
Old 06-06-2014
Ohh my god !!! it works perfectly what i was looking for. Thank you so so so much. Lovely.

---------- Post updated at 04:04 PM ---------- Previous update was at 03:54 PM ----------

Don't mind if am asking one more help.
is it possible to get one more o/p like this

Code:
2014-06-05-18.25.50.122294-240 E12133254A502      LEVEL: Info
PID     : 25100668             TID  : 48159       PROC : db2sysc 0
INSTANCE: udbsjfx1             NODE : 000         DB   : DBNPM01P
APPHDL  : 0-18561              APPID: *LOCAL.udbpa166.140605200020
AUTHID  : UDBPA166
EDUID   : 48159                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
207743524864

I want to extract like this
Code:
2014-06-05-18.25, udbsjfx1, DBNPM01P, 207743524864

Last edited by Don Cragun; 06-06-2014 at 05:16 PM.. Reason: Add CODE tags.
# 4  
Old 06-06-2014
Code:
awk '{printf("%16.16s, %s, %s, %s\n", $1,$16,$22,$NF)}' RS="" file

# 5  
Old 06-06-2014
See my response in the other thread:

https://www.unix.com/302904832-post2.html
This User Gave Thanks to Aia For This Post:
ernie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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 :... (3 Replies)
Discussion started by: jcdole
3 Replies

2. 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... (6 Replies)
Discussion started by: arunkumar_mca
6 Replies

3. 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... (5 Replies)
Discussion started by: stinkefisch
5 Replies

4. 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... (7 Replies)
Discussion started by: AshwaniSharma09
7 Replies

5. 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. (4 Replies)
Discussion started by: shoaibjameel123
4 Replies

6. 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... (5 Replies)
Discussion started by: TestTomas
5 Replies

7. 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,... (7 Replies)
Discussion started by: Bijayant Kumar
7 Replies

8. 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. (6 Replies)
Discussion started by: priyam
6 Replies

9. 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... (20 Replies)
Discussion started by: Raynon
20 Replies

10. 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... (6 Replies)
Discussion started by: aajan
6 Replies
Login or Register to Ask a Question