Need to find only unique values for a given tag across the files:
For eg:
Test1:
<Tag1>aaa</Tag1>
<Tag2>bbb</Tag2>
<Tag3>ccc</Tag3>
Test2:
<Tag1>aaa</Tag1>
<Tag2>ddd</Tag2>
<Tag3>eee</Tag3>
Test3:
<Tag1>aaa</Tag1>
<Tag2>ddd</Tag2>
<Tag3>eee</Tag3>
Test4: (8 Replies)
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Hi all,
I have a huge csv file with the following format of data,
Num SNPs, 549997
Total SNPs,555352
Num Samples, 157
SNP, SampleID, Allele1, Allele2
A001,AB1,A,A
A002,AB1,A,A
A003,AB1,A,A
...
...
...
I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Hi, I have tab-deliminated data similar to the following:
dot is-big 2
dot is-round 3
dot is-gray 4
cat is-big 3
hot in-summer 5
I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows:
dot 3
cat 1
hot 1
is... (5 Replies)
cat sample.csv
ID,Name,no
1,AAA,1
2,BBB,1
3,AAA,1
4,BBB,1
cut -d',' -f2 sample.csv | sort | uniq
this gives only the 2nd column values
Name
AAA
BBB
How to I get all the columns of CSV along with this? (1 Reply)
Hi Folks,
I have the below feed file named abc1.txt in which you can see there is a title and below is the respective values in the rows and it is completely pipe delimited file ,.
... (4 Replies)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
Hi,
I have multiple files that each contain four columns of strings:
File1:
Code:
123 abc gfh 273
456 ddff jfh 837
789 ghi u4u 395
File2:
Code:
123 abc dd fu
456 def 457 nd
891 384 djh 783
I want to compare the strings in Column 1 of File 1 with each other file and Print in... (3 Replies)
What is an efficient way of counting the number of unique values in a 400 column by 1000 row array and outputting the counts per column, assuming the unique values in the array are:
A, B, C, D
In other words the output should look like: Value COL1 COL2 COL3
A 50 51 52... (16 Replies)
Discussion started by: Geneanalyst
16 Replies
LEARN ABOUT DEBIAN
vzlist
vzlist(8) Containers vzlist(8)NAME
vzlist - show various information about containers
SYNOPSIS
vzlist [-a | -S] [-n] [-H] [-o name[,name...] | -1] [-s [-]name] [-h pattern] [-N pattern] [-d pattern] [CTID [CTID ...]]
vzlist -L | --list
vzlist --help
DESCRIPTION
This utility is used for listing containers and their parameters. By default only running containers are listed. If one or more CTIDs are
specified, only specified containers are displayed.
For the fields that can have many values (e.g. ip), all the values are displayed only for the last (i.e. leftmost) column; otherwise, only
the first value is shown.
OPTIONS -a, --all
List all containers.
-S, --stopped
List only not running containers (including the ones with status shown as mounted or suspended).
-n, --name
Display container names instead of hostnames.
-H, --no-header
Suppress displaying the header row.
-o, --output field[,field...]
Display only the specified fields (see Standard fields subsection below).
-1 Synonym for -H -octid, i.e. only show container IDs, one per line.
-s, --sort [-]field
Sort by the value of field (possible arguments are the same as for -o). The - before the field name means sorting in the reverse
order.
Output filters
List of CTs can be further filtered using the following options. For patterns one can use the same wildcards as in shell (i.e. *, ?, and
[]). Note: to avoid expansion of wildcards by the shell, one have to escape the pattern by either putting it into single quotes (like
'a*a') or by adding a backslash before the wildcard character (like a*a).
-h, --hostname pattern
List only containers whose hostnames matches the pattern.
-N, --name_filter pattern
List only containers whose names matches the pattern.
-d, --description pattern
List only containers with descriptions matching the pattern.
Possible fields
-L, --list
list all available format specifiers that can be used for both output (-o, --output) and the sorting order (-s, --sort).
For the user beancounter fields, if suffix is not specified, current usage (a.k.a. "held") value is show. One can also use the fol-
lowing suffixes:
.m maxheld
.b barrier
.l limit
.f fail counter
For the disk quota fields, if suffix is not specified, current usage is shown. One can also use the following suffixes:
.s soft limit
.h hard limit
EXAMPLES
vzlist -o ctid,kmemsize,kmemsize.l -s kmemsize
Show CTIDs, kmemsize usage, and kmemsize limit for all running containers, sorted by the kmemsize usage.
EXIT STATUS
Returns 0 upon success.
COPYRIGHT
Copyright (C) 2000-2011, Parallels, Inc. Licensed under GNU GPL.
OpenVZ 4 Jul 2011 vzlist(8)