Sponsored Content
Full Discussion: Sorting issue
Top Forums Shell Programming and Scripting Sorting issue Post 302943664 by Junaid Subhani on Monday 11th of May 2015 04:21:22 PM
Old 05-11-2015
Sorting issue

Hi All,

I am working on a huge pile of data. Its about a service initiating a call and and finishing it.

The columns that I have is:
Code:
Date          Time         URL                           Call Type           ServiceName
5/11/2015	15:00:00	http-/0.0.0.0:8091-9	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:15	http-/0.0.0.0:8091-22	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:17	http-/0.0.0.0:8091-6	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:01	http-/0.0.0.0:8091-9	finished call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:16	http-/0.0.0.0:8091-22	finished call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:17	http-/0.0.0.0:8091-6	finished call	queryPrepaidBalanceAndThresholdInfo

The end result I want is:

Code:
5/11/2015	15:00:00	http-/0.0.0.0:8091-9	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:01	http-/0.0.0.0:8091-9	finished call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:15	http-/0.0.0.0:8091-22	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:16	http-/0.0.0.0:8091-22	finished call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:17	http-/0.0.0.0:8091-6	going to call	queryPrepaidBalanceAndThresholdInfo
5/11/2015	15:00:18	http-/0.0.0.0:8091-6	finished call	queryPrepaidBalanceAndThresholdInfo


For each Service Name, I would like to have its corresponding "going to call" and "finished call" against URL sorted out.

Is there any command that can help me in this regard ?

Or does this require a complex script ?

Regard

Last edited by Don Cragun; 05-11-2015 at 06:33 PM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix Arithmatic operation issue , datatype issue

Hi, I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ). Eg: 0000001 0000220 0001235 0000022 0000023 ........... ......... ........ Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies

2. Shell Programming and Scripting

Sorting :

Hi .... iam having a file with 20,000 rows and 56 colums. Iam trying to sort a file ....for that iam using 'sort' command. If iam having 3 and 5 key colums etc ... as numerical this 'sort' command will work? what ihave to do ? sample example : E100|0|19940102|1|11111|E003... (3 Replies)
Discussion started by: satyam_sat
3 Replies

3. Shell Programming and Scripting

Sorting Issue

Hi Guys, I am very new to Unix.Can anyone tell me how to sort a file based on fields. For example, I am having a file whose contents are mentioned below: 2233|charles harris |g.m. |sales |12/12/52| 90000 9876|bill johnson |director... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

4. UNIX for Dummies Questions & Answers

Issue on sorting

Hi, I have a file which has data as path/1.xml path/2.xml,...(each in separate lines) I want to sort this file in order. It is not working when I give "sort filename" The number of "/" in path can vary. Thanks, Floyd (1 Reply)
Discussion started by: asmfloyd
1 Replies

5. Shell Programming and Scripting

Sorting

I've been on holiday, and the brain's clearly not back in gear yet... On Solaris, I have a simple list of package names... DGBUpPost1.43_R1 DGSApp1.44_S1 DGSApp1.47_V1 DGSApp1.48_W0 DGPEuroC1.10_K0 DGPEuroC1.11_L0 DGPEuroC1.9_J0 DGSRet1.10_K0 I just want to properly sort them into... (2 Replies)
Discussion started by: JerryHone
2 Replies

6. Shell Programming and Scripting

Sorting issue with directory and file name

Hi All, My folder contains the files as: $ ls -lrt total 50 lms_prap_rf_20100422_99.xml lms_prap_rf_20100422_9.xml lms_prap_rf_20100422_100.xml lms_prap_rf_20100422_10.xml lms_prap_rf_20100426_1.xml I need to get the sorting of the above file based on numbers. I need first file in... (5 Replies)
Discussion started by: sreejitnair123
5 Replies

7. UNIX for Advanced & Expert Users

HELP on sorting

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies

8. Shell Programming and Scripting

sorting issue

I have files with the name myfile_YYMMDD.txt I need to sort them by their date stamp. I know this will work. ls -lrt * | awk '{print $9}' | cut -d "_" -f3 | sort However, it just returns YYMMDD.txt I can then append the myfile_ to it. However, that myfile_ may change. How do... (1 Reply)
Discussion started by: guessingo
1 Replies

9. Shell Programming and Scripting

Need assistance with a file issue and a terminal issue

Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies

10. Shell Programming and Scripting

Variable value substitution issue with awk command issue

Hi All, I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command. The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
ATF-SH(1)						    BSD General Commands Manual 						 ATF-SH(1)

NAME
atf-sh [-s shell] -- interpreter for shell-based test programs SYNOPSIS
atf-sh script DESCRIPTION
atf-sh is an interpreter that runs the test program given in script after loading the atf-sh(3) library. atf-sh is not a real interpreter though: it is just a wrapper around the system-wide shell defined by ATF_SHELL. atf-sh executes the inter- preter, loads the atf-sh(3) library and then runs the script. You must consider atf-sh to be a POSIX shell by default and thus should not use any non-standard extensions. The following options are available: -s shell Specifies the shell to use instead of the value provided by ATF_SHELL. ENVIRONMENT
ATF_LIBEXECDIR Overrides the builtin directory where atf-sh is located. Should not be overridden other than for testing purposes. ATF_PKGDATADIR Overrides the builtin directory where libatf-sh.subr is located. Should not be overridden other than for testing purposes. ATF_SHELL Path to the system shell to be used in the generated scripts. Scripts must not rely on this variable being set to select a specific interpreter. EXAMPLES
Scripts using atf-sh(3) should start with: #! /usr/bin/env atf-sh Alternatively, if you want to explicitly choose a shell interpreter, you cannot rely on env(1) to find atf-sh. Instead, you have to hardcode the path to atf-sh in the script and then use the -s option afterwards as a single parameter: #! /path/to/bin/atf-sh -s/bin/bash ENVIRONMENT
ATF_SHELL Path to the system shell to be used in the generated scripts. SEE ALSO
atf-sh(3) BSD
September 27, 2014 BSD
All times are GMT -4. The time now is 07:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy