03-07-2012
Print lines containing same values in a group
Hi,
I have a table like this:
Name A1 A2 A3 B1 B2 B3 |
111 abc abc abc cbc cbc cbc |
222 acv acv n_n bbc bbc bbc |
333 bvv bvv bvv cBx ccx ccx |
444 ttk ttk ttk kke kke kke |
555 mcr mcr mcr mcr mcr mcr |
The 1st column is just names of the rows. Columns A1, A2, A3 belongs to group A and columns B1, B2, B3 to B. I need to extract lines containing same element in the columns of each group or both groups.
So desired output is
Name A1 A2 A3 B1 B2 B3 |
111 abc abc abc cbc cbc cbc |
444 ttk ttk ttk kke kke kke |
555 mcr mcr mcr mcr mcr mcr |
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Need awk help to group and print lines to format the output as shown below
INPUT FORMAT
set echo on
set heading on
set spool on
/* SCHEMA1 */ CREATE TABLE T1;
/* SCHEMA1 */ CREATE TABLE T2;
/* SCHEMA1 */ CREATE TABLE T3;
/* SCHEMA1 */ CREATE TABLE T4;
/* SCHEMA1 */ CREATE TABLE T5;... (5 Replies)
Discussion started by: rajan_san
5 Replies
2. Shell Programming and Scripting
Hi all,
This should be very easy but I can't figure it out...
I have a file that looks like this:
@SRR057408.1 FW8Y5CK02R652T length=34
AGCAGTGGTATCAACGCAGAGTAAGCAGTGGTAT
+SRR057408.1 FW8Y5CK02R652T length=34
FIIHFF6666?=:88@@@BBD:::?@ABBAAA>8
@SRR057408.2 FW8Y5CK02TBMHV length=52... (1 Reply)
Discussion started by: kmkocot
1 Replies
3. Shell Programming and Scripting
I've this file and need to sort the data in each group
File would look like this ...
cat file1.txt
Reason : ABC
12345-0023
32123-5400
32442-5333
Reason : DEF
42523-3453
23345-3311
Reason : HIJ
454553-0001
I would like to sort each group on the last 4 fileds and print them... (11 Replies)
Discussion started by: prash184u
11 Replies
4. UNIX for Dummies Questions & Answers
Hey guys & gals,
I am hoping for some advice on a sed or awk command that will
allow to only print lines from a file that contain 3 numeric values.
From previous searches here I saw that ygemici used the sed command
to remove lines containing more than 3 numeric values ;
however how... (3 Replies)
Discussion started by: TAPE
3 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
I have a file in below format:
file01.txt
TERM
TERM
TERM
ABC 12315 68.53 12042013 165144
ABC 12315 62.12 12042013 165145
ABC 12315 122.36 12052013 165146
ABC 12315 582.18 12052013 165147
ABC 12316 2.36 12052013 165141
ABC 12316 ... (8 Replies)
Discussion started by: alex2005
8 Replies
7. Shell Programming and Scripting
Hello to all,
I'm trying to print the value corresponding to the words A, B, C, D, E. These words could appear sometimes and sometimes not inside each group of lines. Each group of lines begins with "ZYX".
My issue with current code is that should print values for 3 groups and only is... (6 Replies)
Discussion started by: Ophiuchus
6 Replies
8. Shell Programming and Scripting
Hi, everyone
I have a dataset like this:
A B C D
A C
C D E
F G H
F D K
Y
X A
K K C Gsome of columns have no values in each line. I want to print all lines that have 1/2/3/4 values, export separately to four files. What I expected is like this:
file1
Y
file 2
A C
X Afile 3... (3 Replies)
Discussion started by: nengcheng
3 Replies
9. UNIX for Beginners Questions & Answers
For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt:
PS003,001 MZMWR/ L-DWD// *
PS003,001... (4 Replies)
Discussion started by: jvoot
4 Replies
10. UNIX for Beginners Questions & Answers
I have two directories of files (new-config-files and old-config-files):
new-config-files/this-db/config.inc.php
new-config-files/that-db/config.inc.php
new-config-files/old-db/config.inc.php
new-config-files/new-db/config.inc.php
new-config-files/random-database/config.inc.php
etc.
... (4 Replies)
Discussion started by: spacegoose
4 Replies
LEARN ABOUT MOJAVE
ttk::labelframe
ttk::labelframe(n) Tk Themed Widget ttk::labelframe(n)
__________________________________________________________________________________________________________________________________________________
NAME
ttk::labelframe - Container widget with optional label
SYNOPSIS
ttk::labelframe pathName ?options?
_________________________________________________________________
DESCRIPTION
A ttk::labelframe widget is a container used to group other widgets together. It has an optional label, which may be a plain text string
or another widget.
STANDARD OPTIONS
-class -cursor -takefocus
-style
See the ttk_widget manual entry for details on the standard options.
WIDGET-SPECIFIC OPTIONS
[-labelanchor labelAnchor] Specifies where to place the label. Allowed values are (clockwise from the top upper left corner): nw, n, ne,
en, e, es, se, s,sw, ws, w and wn. The default value is theme-dependent. [-text text] Specifies the text of the label. [-under-
line underline] If set, specifies the integer index (0-based) of a character to underline in the text string. The underlined character is
used for mnemonic activation. Mnemonic activation for a ttk::labelframe sets the keyboard focus to the first child of the ttk::labelframe
widget. [-padding padding] Additional padding to include inside the border. [-labelwidget labelWidget] The name of a widget to use for
the label. If set, overrides the -text option. The -labelwidget must be a child of the labelframe widget or one of the labelframe's
ancestors, and must belong to the same top-level widget as the labelframe. [-width width] If specified, the widget's requested width in
pixels. [-height height] If specified, the widget's requested height in pixels. (See ttk::frame(n) for further notes on -width and
-height).
WIDGET COMMAND
Supports the standard widget commands configure, cget, identify, instate, and state; see ttk::widget(n).
SEE ALSO
ttk::widget(n), ttk::frame(n), labelframe(n)
KEYWORDS
widget, frame, container, label, groupbox
Tk 8.5 ttk::labelframe(n)