Visit The New, Modern Unix Linux Community


Format output from the file to extract "date" section


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Format output from the file to extract "date" section
# 1  
Format output from the file to extract "date" section

Hello Team ,

I have to extract date section from the below file output. The output of the file is as shown below.

Quote:
bash-3.00$ grep -i outofmemory SystemOut.log_bak14122010
[12/14/10 14:43:03:732 CET] 00000041 servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught exception created in one of the service methods of the servlet springDispatcherServlet in application ccrtool. Exception created : org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.OutOfMemoryError: Java heap space
Caused by: java.lang.OutOfMemoryError: Java heap space
[12/14/10 14:46:15:086 CET] 00000041 webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[springDispatcherServlet]: java.lang.OutOfMemoryError: Java heap space
bash-3.00$
I have to extract the "[12/14/10 14:43:03:732 CET]" this section from the above output of the file. can anyone please let me know how can we acheive this?
# 2  
Code:
awk 'NR==1{print $1,$2,$3}' SystemOut.log_bak14122010

# 3  
You could leave out the grep with this:
Code:
$> sed -n '/OutOfMemory/ {s/\].*/]/p}' SystemOut.log_bak14122010
[12/14/10 14:43:03:732 CET]
[12/14/10 14:46:15:086 CET]

This is done with GNU sed. If it wont work with your version of sed, you might have to write it like:
Code:
$> sed -n '
/OutOfMemory/
{
s/\].*/]/p
}
' SystemOut.log_bak14122010

# 4  
Hello cabrao,

I have ran the command and i am getting following error in the output

Code:
bash-3.00$ awk 'NR==1{print $1,$2,$3}' SystemOut.log_bak14122010
************ Start Display
awk: record `[12/14/10 15:54:22:9...' too long
 record number 6014

---------- Post updated at 09:58 AM ---------- Previous update was at 09:56 AM ----------

Hello zaxxon,

I have ran the command and i am getting following output.

Code:
bash-3.00$ sed -n '/OutOfMemory/ {s/\].*/]/p}' SystemOut.log_bak14122010
sed: command garbled: /OutOfMemory/ {s/\].*/]/p}
bash-3.00$

# 5  
I have written, that if the 1st command does not work, you might try the 2nd command I posted. That's due to different versions of sed.

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #26
Difficulty: Easy
IPv6 addresses are 256 bits in length.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

2. UNIX for Beginners Questions & Answers

Extract delta records using with "comm" and "sort" commands combination

Hi All, I have 2 pipe delimited files viz., file_old and file_new. I'm trying to compare these 2 files, and extract all the different rows between them into a new_file. comm -3 < sort file_old < sort file_new > new_file I am getting the below error: -ksh: sort: cannot open But if I do... (7 Replies)
Discussion started by: njny
7 Replies

3. Shell Programming and Scripting

How to increment date using "for loop" in format MMDDYY inside the shell script?

Need to increment the date from "currentdate + 90days" inside the for loop (i=1 to i=50) (5 Replies)
Discussion started by: aroragaurav.84
5 Replies

4. Programming

extract the same format from existing excel file using " Spreadsheet::ParseExcel " module

Hi , can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ??? Example_pgm: Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to... (0 Replies)
Discussion started by: kavi.mogu
0 Replies

5. Shell Programming and Scripting

"links -dump" output format issue

Hi All, I tried searching a lot about this but to no avail. I have a HTML file. I used links -dump file_page.html > text_html.txt What the above command gave me was a filtered text from the HTML file with tags removed. Now, the the output from the above command looked something like this:... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

Can someone help me to convert the date format after get it from the "LAST REBOOT" command.

Can someone help me to convert the date format after get it from the "LAST REBOOT" command. these is the standard output. bash-3.00# last reboot reboot system boot Fri Aug 6 15:07 reboot system down Fri Aug 6 15:04 reboot system boot ... (3 Replies)
Discussion started by: pichitw
3 Replies

8. UNIX for Dummies Questions & Answers

Format output from "echo" command

Hi, I have written a BASH shell script that contains a lot of "echo" commands to notify the user about what's going on. The script generates a log file that contains a copy of what is seen in the terminal. The echo statements are generally verbose, and thus extend out for quite a ways on one... (2 Replies)
Discussion started by: msb65
2 Replies

9. UNIX for Dummies Questions & Answers

converting date format: "May 31 2008" to "2008-05-31"

I have the following script to find out the last day of the last month .... and the output of this script is in the following format ... Script goes like this .... #!/bin/ksh cur_month=`date +%m` cur_year=`date +%Y` prev_month=$(($cur_month-1)) # Check to see if this is January if ... (8 Replies)
Discussion started by: santosham
8 Replies

10. Shell Programming and Scripting

Date increment in the format "YYYYMMDD"

Hi all, I want to increment the date which is in the format "YYYYMMDD". ex: If the date is 20010601 Increment should be: 20010602, 20010603 etc., Any help will be much appreciated. Many Thanks and Regards, Ganapati (4 Replies)
Discussion started by: ganapati
4 Replies

Featured Tech Videos