01-25-2013
Brilliant, both work a treat, thank you!
And I _think_ I follow what is going on, bonus!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a wide and long dataset which looks as follows:
0 3 4 2 3 0 2 2 ...
3 2 4 0 2 2 2 3 ...
0 3 4 2 0 4 4 4 ...
3 0 4 2 2 4 2 4 ...
....
I would like to obtain the minimum of each column (ignoring zero values) so the output would look like:
3 2 4 2 2 2 2 2
I have the... (3 Replies)
Discussion started by: kasan0
3 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: zajtat
6 Replies
3. Shell Programming and Scripting
Hi Friends,
I have the following file
chr1 1 2
chr1 2 3
chr1 3 4
chr1 4 5
chr1 5 6
chr1 19 20
chr1 20 21
chr1 21 22
I want to compare the third column of record 1 to second column of next record and if the difference is zero, consider its third column and match it to next record... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!
Input:
1 1 ABC DEF
2 2 IJK LMN
1 2 ZYX OPW
Output:
1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies
5. Shell Programming and Scripting
Hello,
I have two files as the following:
File1:
F0100020 A G
F0100030 A T
F0100040 A G
File2:
F0100040 A G BTA-28763-no-rs 77.2692
F0100030 A T BTA-29334-no-rs 11.4989
F0100020 A G BTA-29515-no-rs 127.006
I want to sort the second file based on the... (6 Replies)
Discussion started by: Homa
6 Replies
6. Shell Programming and Scripting
hello,
I have a file as follows:
F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692
F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989
F0100030 A T F0100020 A G BTA-29515-no-rs 127.006
F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827
F0100050 A... (9 Replies)
Discussion started by: Homa
9 Replies
7. Shell Programming and Scripting
I have a file like this :
# cat list
cucm, location,76,2
cucm1,location1,76,4
cucm,location,80,8
cucm1,location1,90,8
cucm1,location1,87,11
cucm,location,67,9
and I want output like this :
cucm,location,76,2
cucm1,location1,76,4
cucm,location,80, 6 ===> (8-2 =6)
cucm1,location1,90,4... (5 Replies)
Discussion started by: Lakshmikumari
5 Replies
8. Shell Programming and Scripting
File 1:
20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0
20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0
20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0
File 2:
20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0... (3 Replies)
Discussion started by: Lakshmikumari
3 Replies
9. Shell Programming and Scripting
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies
10. Shell Programming and Scripting
In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13.
I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in... (2 Replies)
Discussion started by: cmccabe
2 Replies
CRMGR(1) Quick Database Manager CRMGR(1)
NAME
crmgr - administration utility for QDBM Curia
SYNOPSIS
crmgr create [-s] [-bnum num ] [-dnum num] name
crmgr put [-kx|-ki] [-vx|-vi|-vf] [-keep|-cat] [-lob] [-na] name key val
crmgr out [-kx|-ki] [-lob] name key
crmgr get [-nl] [-kx|-ki] [-start num] [-max num] [-ox] [-lob] [-n] name key
crmgr list [-nl] [-k|-v] [-ox] name
crmgr optimize [-bnum num] [-na] name
crmgr inform [-nl] name
crmgr remove name
crmgr repair name
crmgr exportdb name dir
crmgr importdb name dir
crmgr snaffle [-kx|-ki] [-ox] [-n] name key
crmgr version
DESCRIPTION
This manual page documents briefly the crmgr commands.
crmgr is a utility for debugging Curia and its applications. It features editing and checking of a database. It can be used for the data-
base applications with shell scripts. This command is used in the above format. name specifies a database name. key specifies the key of a
record. val specifies the value of a record.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#curiacli.
-s make the file sparse.
-bnum num
specify the number of the elements of the bucket array.
-dnum num
specify the number of division of the database.
-kx treat key as a binary expression of hexadecimal notation.
-ki treat key as an integer expression of decimal notation.
-vx treat val as a binary expression of hexadecimal notation.
-vi treat val as an integer expression of decimal notation.
-vf read the value from a file specified with val.
-keep specify the storing mode for `CR_DKEEP'.
-cat specify the storing mode for `CR_DCAT'.
-na do not set alignment.
-nl open the database without file locking.
-start specify the beginning offset of a value to fetch.
-max specify the max size of a value to fetch.
-ox treat the output as a binary expression of hexadecimal notation.
-lob handle large objects.
-n do not output the tailing newline.
-k output keys only.
-v output values only.
SEE ALSO
qdbm(3), crtsv(1), curia(3), cropen(3).
AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>.
This manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>, for the Debian project (but may be used by others).
Man Page 2005-05-23 CRMGR(1)