col1 col2
DOG5 go
DOG5 go
DOG24 stop
DOG76 stop
DOG24 yield
DOG24 halt
to produce this output:
Quote:
col1 col2 go stop yield halt
2 DOG5 2
1 DOG76 1
3 DOG24 1 1 1
As you can tell, I have several unsorted repeating strings in col1 of the input file. Each of these strings has an associated word in col2. Col2 has a total of 4 possible words (go, stop, yield, halt).
The output should have different columns. It should produce the number of times each string repeats in col1. In col2 the output should have the name of the string that is repeating (for ex: DOG5 repeated twice in the input so the output is now displaying the number "2" in col1 and the name "DOG5" in col2).
The other columns in the output should have a column for each of the words that the input col2 had (go, stop, yield, halt). For each string that is now only being shown once in col2, the output should mark how many "go" "stop" "yield" and "halt" each of the col2 strings had. For ex: DOG5 had a total of 2 "go" from the input. DOG5 is also blank for the remaining words because there were no DOG5's in the input that had stop or yield or halt. DOG24 had 1 stop 1 yield and 1 halt from the input and that is now being shown in different columns in the output.
So far, I have this.
Quote:
1 col1
1 DOG76
2 DOG5
3 DOG24
Any ideas?
---------- Post updated at 11:58 AM ---------- Previous update was at 11:55 AM ----------
Apologizes for the formatting issue. The output below may be more readable.
Hi All,
I have a comma separated value (.CSV) file like the one below. The file contains about 20000 lines.
FileName
EmpNo,Name,Age,Sex,Band,Spouse,Children,Salary,
1000,Arnold,24,M,B,N.A.,No,10000,
1001,Jenny,27,F,C,John,2,20000,
...................................
What i need is to... (1 Reply)
Hi All,
I have a tab delimited input file with say 4 fields (columns) as below :
0000443 1AGPR061 2006 Daiml
0002198 1B3XG0K2 1989 Chdds
0002199 1Bd64J0L 1990 Ch34s
0002275 1B3s4J0K 1989 Chadys
0002276 1B465302 2002 Dageml
0002290 1B45430K 1989 Cays
I want the 2nd column in file to... (5 Replies)
Hi,
I need some help.
Shell script counter. i need to add condition to check if counter is more than 10 and longer than 3 hours? it runs every 5 mins. it only check count and send email right now.
it runs in cron as below
gregcount.ksh gregdb 10 > /tmp/gregcount.out 2> /tmp/gregcount.err
... (1 Reply)
Hi Everyone,
I was wondering if someone could help me to transform my data into a format I need.
Here is an example of what my data looks like
E F G H
A 1 2 3 4
B 5 6 7 8
C 9 1 2 3
D 4 5 6 7
and this is what I would need it to look like:
AE 1
BE 5
CE 9
DE 4
AF 2
BF 6
CF 1 (6 Replies)
Hi,
I have a tab delimited text file with three different columns. I want to add an extra column to the text file. The extra column will be the second column and it will equal third column - 1. How do I go about doing that? Thanks!
Input:
chr1 788822 rs11240777
chr1 1008567 rs9442372... (2 Replies)
Hi,
I have an input file in which I need to add a column with the value of part of another column.
I.e. I have the following line (example, not the actual data):
field1,field2,field3,test12,field5,field6I need to get the last two characters of the 4th field, and add them at the end as a... (5 Replies)
Hallo Team,
I have a .csv file. I would like to have another column called Prefix. Under column Prefix i would like to have the first 3 numbers from the theird column.
Other Licenced Operator Alpha Code Numbering Per minute Interconnect Fee per rate group (R Excluding VAT) ... (4 Replies)
In a space delimited file how would you go about removing 2 and 3 column of a file and add "word" to the first column of the file in both awk and vi? (2 Replies)
Hi,
I's like to ask for help with the following question:
this is an example file:
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
I need to have it re-arranged in the following manner: first 2 columns, zero, zero, last two columns, columns 3 to... (6 Replies)
Hi,
I am trying to incorporate 2 functions into my `awk` command.
I want to lower case Column 2 (which is essentially the same information in Col1, except in Col1 I want to maintain the capitalization) and I want to count from 0-N that begins and ends with the start of certain markers that I... (6 Replies)
Discussion started by: owwow14
6 Replies
LEARN ABOUT HPUX
cmhaltcl
cmhaltcl(1m)cmhaltcl(1m)NAME
cmhaltcl - halt a high availability cluster
SYNOPSIS
cmhaltcl [-f] [-v]
DESCRIPTION
cmhaltcl causes all nodes in a configured cluster to stop their cluster daemons, optionally halting all packages or applications in the
process.
To stop a cluster, a user must either be superuser(UID=0), or have an access policy of FULL_ADMIN allowed in the cluster configuration
file. See access policy in cmquerycl(1).
This command will halt all the daemons on all currently running systems. If the user only wants to shutdown a subset of daemons, the
cmhaltnode command should be used instead.
Options
cmhaltcl supports the following options:
-f Force the cluster to shutdown even if packages or group members are currently running. This will cause the packages and group
members to be halted. If a package halt fails, the cluster halt will also fail.
-v Verbose output will be displayed.
RETURN VALUE
cmhaltcl returns the following value:
0 Successful completion.
1 Command failed.
EXAMPLES
Halt the cluster daemons:
cmhaltcl
AUTHOR
cmhaltcl was developed by HP.
SEE ALSO cmquerycl(1m), cmhaltnode(1m), cmruncl(1m), cmrunnode(1m), cmviewcl(1m).
Requires Optional Serviceguard Software cmhaltcl(1m)