Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need to extract a String from log file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to extract a String from log file
# 1  
Old 06-14-2013
Network Need to extract a String from log file
Hi i am having a logfile which contain lot of entires, but i need extract a word after if i found a line that contains a particular string as "ENROLLMENT_EXCEPTION - Exception". please help me in getting a script to do this.

Regards
C. Suresh
# 2  
Old 06-14-2013
Show the data you have and the output you want.
# 3  
Old 06-14-2013
Quote:
Originally Posted by Corona688
Show the data you have and the output you want.
My log entry will contain like the bellow
2013-05-30 08:56:59,951 FJ-eService-s1 ERROR [WebContainer : 4] c.f.m.s.s.i.RegistrationServiceImpl [OCLogger.java:282] activateUser; REGISTR
ATION_ENROLLMENT_EXCEPTION - Exception, xxxxx

in the above after -Exception, it could be any name (name of person) i want to get the name alone.

Regard
Suresh
# 4  
Old 06-14-2013
Check this out, (Assuming the xxxxx string is always the last in that line.).

Code:
awk '/Exception,/{print $NF}' file

# 5  
Old 06-14-2013
Quote:
Originally Posted by rveri
Check this out, (Assuming the xxxxx string is always the last in that line.).

Code:
awk '/Exception,/{print $NF}' file

Great it works for me thanks a lot

Regards
Suresh

---------- Post updated at 12:14 PM ---------- Previous update was at 12:11 PM ----------

Quote:
Originally Posted by rveri
Check this out, (Assuming the xxxxx string is always the last in that line.).

Code:
awk '/Exception,/{print $NF}' file

How can i use a shell script to get the above command out put to be written to a output file.

Regards
Sureh

---------- Post updated at 12:22 PM ---------- Previous update was at 12:14 PM ----------

Quote:
Originally Posted by rveri
Check this out, (Assuming the xxxxx string is always the last in that line.).

Code:
awk '/Exception,/{print $NF}' file

Hi i have done this with a scripts.

Regards
Suresh
# 6  
Old 06-14-2013
>>How can i use a shell script to get the above command out put to be written to a output file.
- Just put the line in the script , and it ll filter out the string , you can redirect and save to another file, depending on your need.
Ex:
Code:
awk '/Exception,/{print $NF}' file > filtered_strings.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract part of string from all log files.?

Hi All, Let us say we have 5 log files, extract the data from all log files and save the output in a file. home/log/first.log home/log/second.log home/log/third.log home/log/four.log home/log/five.log I want to extract the following text from the log files and save the output in a file.... (7 Replies)
Discussion started by: ROCK_PLSQL
7 Replies

2. Shell Programming and Scripting

Extract a string from a file

I have a file with below contents. INCLUDE INCLUDE SYSLIB(SANJ) INCLUDE SYSLIB(BIS) NAME BQTFL(R) dfdg fgbb NAME B i want to grep for "INCLUDE SYSLIB" in the file and do some operation so that my output will be in the bracketed value as below. SANJ BIS Pls let me know how can i... (7 Replies)
Discussion started by: millan
7 Replies

3. Shell Programming and Scripting

Extract a specific string from a file

Hi, I have a file whose contents are as follows. 2013-03-08/15:09:20.134 INFO 00000000-00000000 0034 09700400 CON_IN SessionID:ED5E1400-4805-85E2-17B2-5BE45684886A Connection ID:ED5E1400-4805-68F1-BB1D-F06496BCF910 TO:<sip:51234999@10.239.94.146:5060 FROM:<sip:9302280716@97.208.31.7:51024... (2 Replies)
Discussion started by: SunilB2011
2 Replies

4. Shell Programming and Scripting

extract string from file name between two underscores

Hi, Here is my question, I need to extract string between two underscores from the filename for example, filename is atmos_8xdaily_instant_300x300_1_12.nc what I want to extract is 300x300. There are many such files in my directory, so I guess the code should be like: for file... (7 Replies)
Discussion started by: 1988PF
7 Replies

5. Shell Programming and Scripting

Extract a string between 2 ref string from a file

Hi, May i ask if someone share some command for extracting a string between 2 ref string in a txt file My objective: i had a file with multiple lines and wants only to extract the string "watch?v=IbkAXOmEHpY" or "watch?v=<11 random character>", when i used "grep 'watch?=*' i got a results per... (4 Replies)
Discussion started by: jao_madn
4 Replies

6. Shell Programming and Scripting

Use grep sed or awk to extract string from log file and put into CSV

I'd like to copy strings from a log file and put them into a CSV. The strings could be on different line numbers, depending on size of log. Example Log File: File = foo.bat Date = 11/11/11 User = Foo Bar Size = 1024 ... CSV should look like: "foo.bat","11/11/11","Foo Bar","1024" (7 Replies)
Discussion started by: chipperuga
7 Replies

7. Shell Programming and Scripting

awk extract a string from a file

Hi, I have a file which has thousand of lines with lines starting with And I want to extract and show to user only the below string from all the lines Please note note that the above string is a time stamp and it would be different on all the lines. Please tell me how to extract... (8 Replies)
Discussion started by: jredx
8 Replies

8. Shell Programming and Scripting

Extract a string from file

Below are the content of my file and i need to extract the 6 digit numbers after the word barcode, how can i do this? for example i need to extract 004119,004275,004030 to a new file. Logically move media ID 004119 (barcode 004119) from standalone to slot 18. Logically move media ID 004275... (9 Replies)
Discussion started by: shehzad_m
9 Replies

9. Shell Programming and Scripting

Search for string in a file and extract another string to a variable

Hi, guys. I have one question: I need to search for a string in a file, and then extract another string from the file and assign it to a variable. For example: the contents of the file (group) is below: ... ftp:x:23: mail:x:34 ... testing:x:2001 sales:x:2002 development:x:2003 ...... (6 Replies)
Discussion started by: daikeyang
6 Replies

10. Shell Programming and Scripting

Extract a string from a file

Input File: ===================================== "Server1" srvgrp="group1" srvid=10 CLOPT="-A -r -e /path/logfile -o /path/stdout" VAR1=0666 VAR2=N VAR3=0666 MIN=3 VAR4=4 VAR5=N VAR6=FASTPATH VAR7=5 VAR8=86400 VAR9=Y ... (20 Replies)
Discussion started by: kaustubh137
20 Replies
Login or Register to Ask a Question