Finding common entries between 10 columns Post: 303002517

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Finding common entries between 10 columns Post 303002517 by Sanchari on Saturday 26th of August 2017 06:26:55 AM

08-26-2017

Registered User

Finding common entries between 10 columns

Hello, I need to find the intersection across 10 columns. Kindly help.

my file (INPUT.csv) looks like this

Code:

 4_R         4_S         8_R         8_S         12_R         12_S         24_R         24_S  
LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290 LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290
LOC_Os01g01019 LOC_Os01g01019 LOC_Os01g01019 LOC_Os05g39580 LOC_Os01g01019 LOC_Os01g01019 ChrSy.fgenesh.gene.29 LOC_Os05g39580
LOC_Os01g01019 LOC_Os01g01019 LOC_Os01g01019 LOC_Os05g39580 LOC_Os01g01019 LOC_Os01g01019 ChrSy.fgenesh.gene.29 LOC_Os05g39580
                                                                                   LOC_Os01g01010                                                                                            ChrSy.fgenesh.gene.29
                                                                                                                                                                                                          LOC_Os01g01010

There can be duplicate entries and the no. of entries in each column can be different.

Last edited by Scrutinizer; 08-26-2017 at 09:12 AM.. Reason: Added closing code tag

Sanchari

View Public Profile for Sanchari

Find all posts by Sanchari

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding the most common entry in a column

Hi, I have a file with 3 columns in it that are comma separated and it has about 5000 lines. What I want to do is find the most common value in column 3 using awk or a shell script or whatever works! I'm totally stuck on how to do this. e.g. value1,value2,bob value1,value2,bob...

2. Solaris

Comparing the common columns of a table in two files

Hi, I have two text files.The first and the 2nd file have data in the same format For e.g. The first file has BOOKS COUNT: 40 BOOKS AUTHOR1 SUM:1018 MAX:47 MIN:1 AVG:25.45 BOOKS AUTHOR3 SUM:181 MAX:48 MIN:3 AVG:18.1 Note:Read it as Table columnname sum(column) max(column) min(column)...

3. Shell Programming and Scripting

Finding longest common substring among filenames

I will be performing a task on several directories, each containing a large number of files (2500+) that follow a regular naming convention: YYYY_MM_DD_XX.foo_bar.A.B.some_different_stuff.EXT What I would like to do is automatically discover the part of the filenames that are common to all...

4. Shell Programming and Scripting

Finding Authors in Common Across Dozens of Lists

I currently have publication lists for ~3 dozen faculty members. I need to find out how many publications are in common across all faculty members - person 1 with person 2, person 1 with person 3, person 2 with person 3, person 1 with both person 2 and person 3, etc. One person may have Last1,...

5. Shell Programming and Scripting

finding common numbers (contents) across 2 or 3 files

I have 3 files which are tab delimited and have numbers in it. file 1 1 2 3 4 5 6 7 File 2 3 5 7 8 File 3 1

6. Shell Programming and Scripting

Common records after matching on different columns

Hi, I have the following files. cat 1.txt cat 2.txt output.txt The logic is as follows....

7. Shell Programming and Scripting

Two columns-Common records - 20 files

Hi Friends, I have an input file like this cat input1 x 1 y 2 z 3 a 2 b 4 c 6 d 9 cat input2 x 7 h 8 k 9 l 5 m 9 d 12

8. Shell Programming and Scripting

Common values in 2 columns in 2 files

Hello, Suppose I have these 2 tab delimited files, where the second column in first file contains matching values from first column of the second file, I would like to get an output like this: File A 1 A 2 B 3 C File B A Apple C Cinnabon B Banana I would like...

9. Shell Programming and Scripting

Finding out the common lines in two files using 4 fields with the help of awk and UNIX

Dear All, I have 2 files. If field 1, 2, 4 and 5 matches in both file1 and file2, I want to print the whole line of file1 and file2 one after another in my output file. File1: sc2/80 20 . A T 86 F=5;U=4 sc2/60 55 . G T ...

10. Shell Programming and Scripting

Finding most common substrings

Hello, I would like to know what is the three most abundant substrings of length 6 from col2. The file is quite large and looks like this col1 col2 EN03 typehellobyedogcatcatdog EN09 typehellobyebyebyebye EN08 dogcatcatdogbyebyebyebye EN09 catcattypehellobyebyebyebye...

LEARN ABOUT FREEBSD

lsns

LSNS(8)                                                        System Administration                                                       LSNS(8)

NAME

       lsns - list namespaces

SYNOPSIS

       lsns [options] [namespace]

DESCRIPTION

       lsns  lists  information  about all the currently accessible namespaces or about the given namespace.  The namespace identifier is an inode
       number.

       The default output is subject to change.  So whenever possible, you should avoid using default outputs in your scripts.  Always  explicitly
       define expected columns by using the --output option together with a columns list in environments where a stable output is required.

       Note  that lsns reads information directly from the /proc filesystem and for non-root users it may return incomplete information.  The cur-
       rent /proc filesystem may be unshared and affected by a PID namespace (see unshare --mount-proc for more details).  lsns is not able to see
       persistent namespaces without processes where the namespace instance is held by a bind mount to /proc/pid/ns/type.

OPTIONS

       -J, --json
              Use JSON output format.

       -l, --list
              Use list output format.

       -n, --noheadings
              Do not print a header line.

       -o, --output list
              Specify which output columns to print.  Use --help to get a list of all supported columns.

              The default list of columns may be extended if list is specified in the format +list (e.g. lsns -o +PATH).

       -p, --task pid
              Display only the namespaces held by the process with this pid.

       -r, --raw
              Use the raw output format.

       -t, --type type
              Display  the  specified type of namespaces only.  The supported types are mnt, net, ipc, user, pid, uts and cgroup.  This option may
              be given more than once.

       -u, --notruncate
              Do not truncate text in columns.

       -V, --version
              Display version information and exit.

       -h, --help
              Display help text and exit.

AUTHORS

       Karel Zak <kzak@redhat.com>

SEE ALSO

       nsenter(1), unshare(1), clone(2), namespaces(7)

AVAILABILITY

       The lsns command is part of the util-linux package and is available from https://www.kernel.org/pub/linux/utils/util-linux/.

util-linux                                                         December 2015                                                           LSNS(8)