Note - do this in a small subdirectory it uses tempfiles. If your first column has too many distinct values it will not work either. This depends on system's your open file limit. You'll have to resort to something else.
Code:
getconf OPEN_MAX
tells you how many open files you can have at one time.
Hi,
I've a fixed width file where I need to count the number of patterns from each line between characters 1 to 15 . so can we sort them and get a count for each pattern on the file between 1 to 15 characters.
65795648617522383763831552 410828003265795648 6175223837... (5 Replies)
Hello!
I have a file with 4 columns. I am trying to have it sort first with respect to the first column, and then with respect to the number of counts (in descending count) in the second column within the same first column identity.
For example:
Input:
1 2 A 1
1 6 B 2
2 5 G 7
1 6 D 4
1... (1 Reply)
I want to sort lines by how many times a string occurs in each line (the most times first).
I know how to do this in two passes (add a count field in the first pass then sort on it in the second pass).
However, can it be done more optimally with a single AWK command? My AWK has improved... (11 Replies)
Hi,
I'm new to linux & bash so please forgive my ignorance, just wondering if anyone can help.
I have a file (mainfile.txt) with comma deliminated values, like so:
$1 $2 $3
613212, 36, 57
613212, 36, 10
613212, 36, 10
677774, 36, 57
619900, 10, 10
i need to split this file... (12 Replies)
Can any one please help I am trying to sort each item in every line and count the common (non case sensitive) and at the end printing all the unique alphabetically.
Here is what i did ... I can print all the lines but struck to sort each line some were:
I am getting the output as:
I... (5 Replies)
I am trying to count a special character in several thousand files and sort the result according to the number the character occured in each files.
files:
1.txt
2.txt
3.txt
files look like:
ABCDEFGHABBBACF
I want the number of B in each file and a result file that lists the occurence... (4 Replies)
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)
Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out.
I have several text files that contain data in many columns. All the files are organized the same... (14 Replies)
hi all,
i want to get the most comon column w.r.t another
this is my file
Tom|london
Tom|london
Tom|Paris
Adam|Madrid
Adam|NY
the Output to get me :
Tom|london
Adamn|Madrid
ive tried (10 Replies)
Hi Folks :)
I have a .txt file with thousands of words. I'm trying to sort the lines in order based on number of words per line.
Example
from:
word
word word word
word word
word word word word
word
word word word
word word
to desired output:
word (2 Replies)
Discussion started by: martinsmith
2 Replies
LEARN ABOUT ULTRIX
ruptime
ruptime(1c)ruptime(1c)Name
ruptime - show host status of local machines
Syntax
ruptime [ options ] [ machinename ]
Description
The command gives a status line like for each machine on the local network. If a machinename is given, the status of only the named
machine is given. These status lines are formed from packets broadcast by each host on the network once a minute.
Machines for which no status report has been received for 5 minutes are shown as being down.
Options-a Users idle an hour or more are not counted unless this option is specified.
-d Display only those hosts that are considered down.
-l Sort the status list by load average. If more than one sort option is given, uses the last one.
-r Show only hosts that are up and running.
-t Sort the status list by uptime. If more than one sort option is given, uses the last one.
-u Sort the status list by number of users. If more than one sort option is given, uses the last one.
-nn Show only those hosts with nn or more users.
Restrictions
Because the daemon sends its information in broadcast packets it generates a large amount of network traffic. On large networks the extra
traffic may be objectionable. Therefore, the daemon is disabled by default. To make use of the daemon for both the local and remote
hosts, remove the comment symbols (#) from in front of the lines specifying in the file.
If the daemon is not running on a remote machine, the machine may incorrectly appear to be down when you use the command to determine its
status. See the reference page for more information.
If a system has more than 40 users logged in at once, the number of users displayed by the command is incorrect. Users who login to a
machine after that point fail to increment the user count that appears in the output of the command. This is due to the maximum size limit
of an Ethernet packet, which is 1500 bytes, and the fact that the daemon must broadcast its information in a single packet.
Files
/usr/spool/rwho/whod.* Information about other machines
See Alsorwho(1c), rwhod(8c)ruptime(1c)
04-08-2010
