I want to mege the rows based on first column with same ID. In column 2, I want only ID starting with PF and in 3rd column, want to concatenate all GO term seperated with comma. in each case there should be no duplicate eg:
Thankyou
Last edited by anjaliANJALI; 08-13-2019 at 01:43 PM..
Hi,
I have two files consisting of two columns. So I want to merge column 2 if column 1 is the same. So heres an example of what I mean.
FILE1
driver 444
car 333
hat 222
FILE2
driver 333
car 666
hat 999
So I want to merge the column 2's together so... (4 Replies)
Guys,
i have a file in below format where the barcode's are uniq per site but could be repeated for different site. so i want to convert the site column to rows based on the barcode's as below output.
your help is appreciated!!!
input:
SITE BARCODE QTY SP CP
10001 6281103890017 10 50 48... (5 Replies)
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
I had two files file1 and file2. I want a o/p file(file3) like below using first column as ref. Pls give suggestion ass join is not working as the number of lines in each file is nealry 5 C?
file1
---------------------
404000324810001 Y
404000324810004 N
404000324810008 Y
404000324810009 N... (1 Reply)
I have the following space-delimited input:
1 11.785710 117.857100
1 15 150
1 20 200
1 25 250
3 2.142855 21.428550
3 25 250
22 1.071435 10.714350
The first field is the ID number, the second field is the percentage of the total points that the person has and the third column is the number... (3 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Hi,
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
File
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Hello :)
I am in this situation:
Input: two tab-delimited files, `File1` and `File2`. `File2` (`$2`) has to be parsed by patterns found in `File1` (`$1`).
Expected output: tab-delimited file, `File3`. `File3` has to contain the same rows as `File2`, plus the corresponding value in... (5 Replies)
I Want to merge multiple lines based on the 1st field and keep into single record.
SRC File:
AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6
OUTPUT
-----------------
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies
LEARN ABOUT LINUX
madison-lite
MADISON-LITE(1) Debian General Commands Manual MADISON-LITE(1)NAME
madison-lite -- display versions of Debian packages in an archive
SYNOPSIS
madison-lite [--config-file file] [--mirror directory] [--nocache] [--update] [-S] [-r] [-a architecture[,...]] [-c component[,...]]
[-s suite[,...]] package [...]
DESCRIPTION
madison-lite inspects a local Debian package archive and displays the versions of the given packages found in each suite (for example,
stable, testing, or unstable) in a brief but easily human-readable form. It aims to be a drop-in replacement for the madison utility (since
renamed to dak ls), from the dak archive management suite that runs on the central Debian archive systems, but one which can run without
access to the archive's SQL database.
The following options are available:
--config-file file
Read configuration from file, and ignore the system configuration file (see CONFIGURATION below).
--mirror directory
Quick configuration: use directory as the top level of the Debian mirror.
--nocache
Normally, parts of the Packages and Sources files in the archive are cached in ~/.madison-lite/cache for speed. This option disables
that behaviour.
--update
Force caches of Packages and Sources files to be updated.
-S, --source-and-binary
Interpret package as a source package name, and display versions of any associated binary packages as well as of the source package.
-r, --regex
Interpret package as a Perl regular expression anchored at the start of the package name rather than as an exact name. Make sure to
quote any shell metacharacters such as '*' or '?' if necessary.
-a, --architecture architecture[,...]
Display only entries for packages built for these architectures. Separate multiple architectures with commas or spaces.
-c, --component component[,...]
Display only entries in the given components. Separate multiple components with commas or spaces.
-s, --suite suite[,...]
Display only entries in the given suites. Separate multiple suites with commas or spaces.
CONFIGURATION
madison-lite reads configuration information from the file named by --config-file, or, if that is not supplied, from the first of
~/.madison-lite/config and /etc/madison-lite/config that exists.
The following configuration directives are recognized:
mirror directory
Set the top-level directory of the local Debian mirror. Relative directories in the suite directive are interpreted relative to this
directory. Defaults to the current directory.
suite name directory [component [...]]
Defines the suite name based at directory, containing the specified components (defaulting to all subdirectories of directory). Output
is displayed following the order of suite directives in the configuration file. If no suite directives are present, then every subdi-
rectory of the dists directory under mirror is treated as a suite, with all of their subdirectories as components.
The Debian archive is structured such that the subdirectories of each suite directory identify components (such as main). Each of
those in turn has subdirectories for each architecture (binary-i386, and so on), each of which contains any or all of Packages,
Packages.gz, and Packages.bz2 files listing binary packages; it also has a subdirectory called source which contains any or all of
Sources, Sources.gz, and Sources.bz2 files listing source packages.
The configuration file may contain comment lines, which start with a '#' character.
EXAMPLES
Show versions of the coreutils package:
$ madison-lite coreutils
Show versions of all binary packages on powerpc produced by the glibc source package:
$ madison-lite -S -a powerpc glibc
Show versions of all packages in the unstable suite whose names begin with 'man':
$ madison-lite -s unstable -r 'man.*'
An example configuration file for a simple local mirror:
mirror /mirror/debian
suite unstable dists/unstable main
suite unstable-non-US non-US/dists/unstable non-US/main
SEE ALSO dpkg-scanpackages(8), dpkg-scansources(8), apt-ftparchive(1)AUTHORS
madison-lite was written by Colin Watson <cjwatson@debian.org>. The interface mirrors that of madison (since renamed to dak ls), written by
James Troup.
Debian August 1, 2007 Debian