|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk/sed to extract column bases on partial match
Post 302511527 by Franklin52 on Thursday 7th of April 2011 03:52:27 AM
04-07-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am having file which contains around 15 columns, i need to fetch column 3,12,14 based on the condition that column 3 starts with 40464
this is the sample data
how to achieve that (3 Replies)
Discussion started by: aemunathan
3 Replies
2. Shell Programming and Scripting
Hello,
Let's assume I have 100 files FILE_${m} (0<m<101). Each of them contains 100 lines and 10 columns.
I'd like to get in a file called "result" the average value of column 3, ONLY between lines 11 and 17, in order to plot that average as a function of the parameter m.
So far I can compute... (6 Replies)
Discussion started by: DMini
6 Replies
3. Shell Programming and Scripting
FILE A:
9780743551526,(Abridged)
9780743551779,(Unabridged)
9780743582469,(Abridged)
9780743582483,(Unabridged)
9780743563468,(Abridged)
9780743563475,(Unabridged)
FILE B:
c3saCandyland 9780743518321 "CANDYLAND" "MCBAIN, ED" 2001
c3sbCandyland 9780743518321 ... (7 Replies)
Discussion started by: glev2005
7 Replies
4. Shell Programming and Scripting
Hello, this is probably a simple request but I've been toying with it for a while.
I have a large list of devices and commands that were run with a script, now I have lines such as:
a-router-hostname-C#show ver
I want to print everything up to (and excluding) the # and everything after it... (3 Replies)
Discussion started by: ippy98
3 Replies
5. Shell Programming and Scripting
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Discussion started by: Diya123
1 Replies
6. Shell Programming and Scripting
awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
7. UNIX for Dummies Questions & Answers
Hi I have a question and hope I can get answer here. Thank you in advance.
I have two files:
file1:
aa X
bb Y
cc Z
file2:
cc A
bb B
dd C
aa D
bb E
If the 1st column match in both file1 and file2, the 2nd column in file2 will be replaced by the 2nd column in file1. If there is no... (2 Replies)
Discussion started by: yuejian
2 Replies
8. Shell Programming and Scripting
Trying to combine strings that are a partial match to another in $1 (usually below it). If a match is found than the $2 value is added to the $2 value of the match and the $3 value is added to the $3 value of the match. I am not sure how to do this and need some expert help. Thank you :).
file
... (2 Replies)
Discussion started by: cmccabe
2 Replies
9. Shell Programming and Scripting
Trying to get the unique count of the below input, but if the text in beginning of $5 is a partial match to another line in the file then it is not unique.
awk
awk '!seen++ {n++} END {print n}' input
7 input
chr1 159174749 159174770 chr1:159174749-159174770 ACKR1
chr1 ... (2 Replies)
Discussion started by: cmccabe
2 Replies
10. Shell Programming and Scripting
I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output.
$1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT OSF1
ruptime
ruptime(1) General Commands Manual ruptime(1) NAME
ruptime - Displays the status of each host on a network SYNOPSIS
ruptime [-ar] [-l | -t | -u] ruptime [-ar] [-l | -t | -u] [machinename] The ruptime command displays the status of each host on a local network that is running the rwhod daemon. If machinename is specified, only the status of that machine is displayed. OPTIONS
Includes all users. Without this option, users whose sessions are idle an hour or more are not included. Sorts the list by the load aver- age over 5-, 10-, and 15-minute intervals prior to a server's transmission. The load averages are multiplied by 10 to represent the value in decimal format. Reverses the sort order. Sorts the list by the length of uptime. Sorts the list by the number of users. DESCRIPTION
The status lines are sorted by hostname unless the -l, -t, or -u option is indicated. The status information is provided in packets broad- cast once every 3 minutes by each network host running rwhod. Any activity (such as the power to a host being turned on or off) that takes place between broadcasts is not reflected until the next broadcast. Hosts for which no status information is received for 11 minutes are reported as down. EXAMPLES
To get a status report on the hosts on the local network, enter: $ ruptime Information similar to the following is displayed: host1 up 5:15, 4 users, load 0.09, 0.04, 0.04 host2 up 7:45, 3 users, load 0.08, 0.07, 0.04 host3 up 2:28, 0 users, load 0.01, 0.02, 0.03 host4 up 3+01:44, 1 user, load 0.01, 0.02, 0.03 host7 up 7:43, 1 user, load 0.06, 0.12, 0.11 (Output may be formatted differently on your system.) To get a status report sorted by load average, enter: $ ruptime -l Information similar to the following is displayed: host2 up 7:45, 3 users, load 0.08, 0.07, 0.04 host1 up 5:18, 4 users, load 0.07, 0.07, 0.04 host7 up 7:43, 1 user, load 0.06, 0.12, 0.11 host3 up 2:28, 0 users, load 0.01, 0.02, 0.03 host4 up 3+01:44, 1 user, load 0.01, 0.02, 0.03 (Output may be formatted differently on your system.) FILES
Indicates data files received from remote rwhod daemons. SEE ALSO
Commands: rwho(1), rwhod(8) ruptime(1)