Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Sorting a text file with respect to Function/Keyword

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sorting a text file with respect to Function/Keyword
# 8  
Old 12-29-2014
Those two lines are not in the sample file you provided. However, let's take advantage of the time stamp entry's first three parts being of constant length and sort the fourth part numerically. Try
Code:
sort -t"|" -k3,4 -k6.17,6n /tmp/timeprofile_log.txt |
awk     '$5=="ENTRY"            {if (N) printf "\n"
                                 N=1
                                 printf "%s", $0
                                 next
                                }
         $5=="EXIT"             {if (N) sub("^.*"$4"\|", "")
                                 print
                                }   
                                {N=0
                                }
        ' FS="|"

This still doesn't help when the entries are not in temporal order.
# 9  
Old 01-06-2015
Hi Rudic ,
Wish you a Very very happy and prosperous new year.

Thank you so much for your piece of excellent code.
Would you please help me further to add one more column which is elapsed time for a certain function(Exit - Entry time)Smilie
Input
|TIME|THREAD_ID:3070363080|ake_socketSendBuffer|ENTRY|11:02:17:104951|
|TIME|THREAD_ID:3070363080|ake_socketSendBuffer|EXIT|11:02:17:105874|
Output
|TIME|THREAD_ID:3070363080|ake_socketSendBuffer|ENTRY|11:02:17:104951|EXIT|11:02:17:105874|00:00:00: 923

I am attaching a fresh Input file. Kindly refer the same.

BR,
PD
timeprofile_log1_trimmed_2.txt (2.66 MB) 
Last edited by pradyumnajpn10; 01-06-2015 at 06:15 AM..
# 10  
Old 01-06-2015
Try
Code:
awk     '$5=="ENTRY"            {if (N) printf "\n"
                                 N=1
                                 split ($(NF-1),T,":")
                                 ST=((T[1]*60+T[2])*60+T[3])*1E6+T[4]
                                 printf "%s", $0
                                 next
                                }
         $5=="EXIT"             {if (N) {sub("^.*"$4"\|", "")
                                         split ($(NF-1),T,":")
                                         $NF=((T[1]*60+T[2])*60+T[3])*1E6+T[4] - ST
                                        }
                                 print
                                }
                                {N=0
                                }
        ' FS="|" OFS="|" file
|TIME|THREAD_ID:3070363080|ake_socketSendBuffer|ENTRY|11:02:17:104951|EXIT|11:02:17:105874|923

This won't work across midnight, and the last column's formatting is left to you.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append a specific keyword in a text file into a new column

All, I have some sample text file(.csv) in the below format. In my actual file there are at least 100K rows. date 03/25/2016 A,B,C D,E,F date 03/26/2016 1,2,3 4,5,6 date 03/27/2016 6,4,3 4,5,6 I require the following output where in the date appeared at different locations need to... (3 Replies)
Discussion started by: ks_reddy
3 Replies

2. Shell Programming and Scripting

Search for a Keyword in file and replace another keyword or add at the end of line

Hi I want to implement something like this: if( keyword1 exists) then check if(keyword2 exists in the same line) then replace keyword 2 with New_Keyword else Add New_Keyword at the end of line end if eg: Check for Keyword JUNGLE and add/replace... (7 Replies)
Discussion started by: dashing201
7 Replies

3. Shell Programming and Scripting

cut with delimiter respect text

Hi, Can someone help me to get the shortest command Input file ========= I|know|"english|french" It|can|have|four|delimiters Desired output =========== "english|french" have If I use cut -d "|" -f3 , i am getting "english as 3rd field.But I would like to get the whole text in... (2 Replies)
Discussion started by: anandapani
2 Replies

4. UNIX Desktop Questions & Answers

Problem in sorting a text file

Hi; I have a text file like this: 1 10 11 2 3 4 M X Y When I sort it numerically using sort -n, it looks like this: Y X M 1 2 3 4 10 (3 Replies)
Discussion started by: a_bahreini
3 Replies

5. Shell Programming and Scripting

sorting based on a specified column in a text file

I have a tab delimited file with 5 columns 79 A B 20.2340 6.1488 8.5086 1.3838 87 A B 0.1310 0.0382 0.0054 0.1413 88 A B 46.1651 99.0000 21.8107 0.2203 89 A B 0.1400 0.1132 0.0151 0.1334 114 A B 0.1088 0.0522 0.0057 0.1083 115 A B... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

6. Shell Programming and Scripting

Sorting a text file

In unix how to sort in reverse order based on second field in a text file. $ cat data1 David:501 Albie:503 Shaun:502 The expected output: Albie:503 Shaun:502 David:501 Please help :) (4 Replies)
Discussion started by: jon2ryhme
4 Replies

7. UNIX for Dummies Questions & Answers

Using $0 and 'Function' Keyword

Hi all, I had a query on the usage of $0 in shells. I would appreciate any assistance in this. We moved from a sun solaris server to a linux server. I ran 2 different pieces on these servers and in one case, the outputs didnt change and in the other case, the outputs were different. The 2... (3 Replies)
Discussion started by: novice1324
3 Replies

8. UNIX for Dummies Questions & Answers

sorting files with find command before sending to text file

i need help with my script.... i am suppose to grab files within a certain date range now i have done that already using the touch and find command (found them in other threads) touch -d "$date_start" ./tmp1 touch -d "$date_end" ./tmp2 find "$data_location" -maxdepth 1 -newer ./tmp1 !... (6 Replies)
Discussion started by: deking
6 Replies

9. Shell Programming and Scripting

awk error in sorting text file

Hi Having a file as below file.txt error Server Network Name Dept Date Time =========================================================================================================================== 0 ServerA LAN1 AAA IT01 04/30/2008 09:16:26 0 ... (3 Replies)
Discussion started by: karthikn7974
3 Replies

10. Shell Programming and Scripting

sorting dir with respect to their nr., of files

hello, I've got a lil shell program, which gets some directories as parameters.How can I sort this directories with respect to the nr of files they contain? The dir with the most files should be printed first. i've tried with ls -1|wc -w but i can't save this value and can not save the... (0 Replies)
Discussion started by: atticus
0 Replies
Login or Register to Ask a Question