You can remove the square brackets in the same awk; added a RS at the end (not sure if needed): Edit:
Sorry, just noticed you wanted also to remove duplicates and a sort too.
Last edited by zaxxon; 08-11-2010 at 06:50 AM..
Reason: Didn't read needs properly
Hi,
I currently have many log files for different webpages inside the folder /log/. The program allows the user to enter a month and then the grep function searches for it, the command i used is below:
grep -c "$month" ./log/*.log
This works and i can ascertain the number of matches, but I... (10 Replies)
Hi, I have used the following code to sort two sets of data:
awk '{printf "%10s %s\n",$1,$2}'
The first column is text and the second involves numbers. I was just wondering how i would go about sorting the second number so that they ascend from the top?
Thanks for any help (4 Replies)
i have following file have following type of data
1~%%~fcashfafh~%%~9797
can i sort(numeric) the file on first field and then on last feild using awk (3 Replies)
Hi,
I have a file which is:-
1 6 4 8 2 3
2 1 9 3 2 1
3 3 5 6 3 1
4 9 7 8 2 3
I would like to sort from field $2 to field $6 for each of the line to:-
1 2 3 4 6 8
2 1 1 2 3 9
3 1 3 3 5 6
4 2 3 7 8 9
I came across this Arrays on example 26-6. But it is much complicated. I am... (7 Replies)
I need to sort this input using sed, awk or any other tool to give below output
Input:
RXOCF-8
CLASS 2A
57
RU
40
RXORX-8-0
CLASS 1B
23 45 16
RXORX-8-1
EXTERNAL CLASS 2A (12 Replies)
I have an array with five columns and i want to write it to a file.
Before writing it i must sort it using the field in the fifth column.
_________________________________________
|field 1|field 2|field 3|field 4|field 5|
| | | | | |
| | | |... (6 Replies)
Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort:
sample name, miRNA, reads per million (RPM)
There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Hello,
I have a file which has the following format: I have to do is sort individual records in the file based on the 4th field. Each record starts with "Module". Is there an easy way to do this using awk. I have tried piping output from awk to sort and also using "sort" inside awk but... (8 Replies)
Hi ,
I have a file which has a large number of sequences of type:
gi_1
AASSKSKSKSSKSKSK....
series_121
DDKFKFKGKGKH
gi_3
FFFFLFFLFLFLF
series_1
DFFFFFF
pattern_3
GEEEEEEEEE
gi_2
HKKGGKGKGK
series_102
HHHHH
pattern_1 (2 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
You will write a script that will read a tab-separated file that contains the names of all 50 states &... (7 Replies)