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:
The end result I want is:
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
I don't know how you get output with an 18 in the seconds field in the output when that value does not appear in any line in your input.
It isn't clear if you are saying that your input file might contain more than one ServiceName field value (since your sample input only has one value in that field). If there is more than one value for that field, it isn't clear whether you want each value in a separate output file or just sorted in one output file.
Now that I have added CODE tags to your post (so we can see that you have tabs as field separators instead of spaces), and assuming that you really want to get rid of the header line from your input and want all of the output in one file when there is more than one ServiceName value, you could try something like:
(where the character between the double quotes is a single literal tab character). This was tested using the Korn shell, but will work with any shell based on Bourne shell syntax.With the sample input you provided, this produces the output:
If you want the header to be copied into the output instead of removing it; add the line:
just before the line:
in the script.
This User Gave Thanks to Don Cragun For This Post:
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)