Following may help you in same, if order doesn't matter for you.
Output will be as follows for without date in 1st command above.
Output will be as follows with date mentioned in 2nd command above.
Thanks,
R. Singh
Last edited by RavinderSingh13; 09-03-2015 at 07:37 AM..
Reason: Added a date condition in code now.
This User Gave Thanks to RavinderSingh13 For This Post:
Hi Gurus,
I have a file
1|usa|hh
2|usa|ll
3|usa|vg
4|usa|vg
5|usa|vg
6|usa|vg
7|usa|ll
8|uk|nn
9|uk|bb
10|uk|bb
11|kuwait|mm
12|kuwait|jkj
13|kuwait|mm
14|dubai|hh
I want to group by last two columns and get the last two recs and count. (3 Replies)
Hi
I have a file containing 1000+ lines of netlist data.
I need to search for text between two key words on each line
for e.g my input file has
"ABC.ABC__312.deftr_0.X143.Xntys_0.\Xetabc__ABC_test_tz .X1023" "ABC.ABC__312.asjartwtsj"... (16 Replies)
Hi All,
I've been trying solve this with a simple command but not having much luck. I have a file like this:
Line 1: random_description 123/alert/high random_description2 356/alert/slow
Line 2: random_description3 654/alert/medium
Line 3: random_description4 234/alert/critical
I'm... (7 Replies)
Hi,
I have a master file that i need to split into multiple files based on matched patterns. sample of my data as follows:-
scaff_1 a e 123 130 c_scaff_100
scaff_1 a e 132 138 c_scaff_101
scaff_1 a e 140 150 ... (2 Replies)
I have a file with the following text:
grep \$
grep \\$
grep \\\$
grep '\$'
grep '\'$'
grep \\
grep \\\\
grep "\$"
grep '"$'
grep "$"
When I perform these same commands on this file, the result are never what I would expect them to be. Could someone please comment on the results and... (3 Replies)
Hi Experts,
I have a log file like this.I need to filter the Index name and elapsed time(only created ).
06:36:39 SQL> create index XYZ_F75 on XYZ
06:36:39 2 ("GRP_ID", "_ID") parallel 64 nologging
06:36:39 3 tablespace XARGS_IDX
06:36:39 4 ;
Index created.
Elapsed:... (2 Replies)
I am trying to grep a variable with multiple lines with multiple patterns
below is the pattern list in a variable called "grouplst", each pattern is speerated by "|"
grouplst="example1|example2|example3|example4|example5|example6|example7"
I need to use the patterns above to grep a... (2 Replies)