Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merge with common column
Top Forums Shell Programming and Scripting Merge with common column Post 302728669 by empyrean on Thursday 8th of November 2012 08:52:37 AM
Old 11-08-2012
Thankyou , pamu

but its printing the headers in three lines on one file and no headers on other file. see the output below.

Code:
123             9a.vcf               hy92.vcf          hy90.vcf
Index    Ref     Alt     Ref     Alt     Ref     Alt
Gene     Position         Reference Base         Alternate Base          Alternate count         Alternate count         Snp format      Sequence
lcl|utg7180000001423     315      A      G      3                [A/G]   CTAGAATCAAAGCAAGAATACACTCTTTTTTTTGGAAAAGAATATCTCATGTTTGCTCTTAAACTCCAAAACATATATCTACTTCAAAGTAGTGTTTTCCTGAGAGAAAGCACTATCGATAAGTTATGTCCCAACTCCAAATTATTACATCAAAGTAGAAACAAGATGACATATATATATCAACCGTATATTCTGCACATGATGTG      315       14       0       7       4      17       2
lcl|utg7180000001423     321      G      A/A,C  41       39,2    [-/-]   CTAGAATCAAAGCAAGAATACACTCTTTTTTTTGGAAAAGAATATCTCATGTTTGCTCTTAAACTCCAAAACATATATCTACTTCAAAGTAGTGTTTTCCTGAGAGAAAGCACTATCGATAAGTTATGTCCCAACTCCAAATTATTACATCAAAGTAGAAACAAGATGACATATATATATCAACCGTATATTCTGCACATGATGTG      321        5       9       3       8       7      11
lcl|utg7180000001423     327      A      C      4                [A/C]   CTAGAATCACTAGAATCAAAGCAAGAATACACTCTTTTTTTTGGAAAAGAATATCTCATGTTTGCTCTTAAACTCCAAAACATATATCTACTTCAAAGTAGTGTTTTCCTGAGAGAAAGCACTATCGATAAGTTATGTCCCAACTCCAAATTATTACATCAAAGTAGAAACAAGATGACATATATATATCAACCGTATATTCTGCACATGATGTG     327       13       0       9       3      16       1

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge based on common, awk help

All, $ cat x.txt z 11 az x 12 ax y 13 ay $ cat y.txt ay TT ax NN Output required: y 13 ay TT x 12 ax NN (3 Replies)
Discussion started by: jkl_jkl
3 Replies

2. Shell Programming and Scripting

merge rows based on a common column

Hi guys, Please guide me if you have a solution to this problem. I have tried paste -s but it's not giving the desired output. I have a file with the following content- A123 box1 B345 bat2 C431 my_id A123 service C431 box1 A123 my_id I need two different outputs- OUTPUT1 A123... (6 Replies)
Discussion started by: smriti_shridhar
6 Replies

3. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Hi All, I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations: 1. I am restrained to 2 input files only. 2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Discussion started by: Katabatic
1 Replies

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns. I want the merge all these text files by the matching values in the second column. In the output, the first column should... (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

Merge rows with common column

Dear all I have big file with two columns A_AA960715 GO:0006952 A_AA960715 GO:0008152 A_AA960715 GO:0016491 A_AA960715 GO:0007165 A_AA960715 GO:0005618 A_AA960716 GO:0006952 A_AA960716 GO:0005618 A_AA960716... (15 Replies)
Discussion started by: AAWT
15 Replies

6. Shell Programming and Scripting

file merge based on common columns

I have two files 1.txt 34, ABC, 7, 8, 0.9 35, CDE, 6.5, -2, 0.01 2.txt 34, ABC, 9, 6, -1.9 35, CDE, 8.5, -2.3, 5.01 So in both files common columns are 1 and 2 so final o/p should look like 34, ABC, 7, 8, 0.9, 9, 6, -1.9 35, CDE, 6.5, -2, 0.01, 8.5, -2.3, 5.01 I tried using... (3 Replies)
Discussion started by: manas_ranjan
3 Replies

7. Shell Programming and Scripting

Count and merge using common column

I have the following records from multiple files. 415 A G 415 A G 415 A T 415 A . 415 A . 421 G A 421 G A,C 421 G A 421 G A 421 G A,C 421 G . 427 A C 427 A ... (3 Replies)
Discussion started by: empyrean
3 Replies

8. Shell Programming and Scripting

Merge files based on both common and uncommon rows

Hi, I have two files A (2190 rows) and file B (1100 rows). I want to merge the contents of two files based on common field, also I need the unmatched rows from file A file A: ABC XYZ PQR file B: >LMN|chr1:11000-12456: >ABC|chr15:176578-187678: >PQR|chr3:14567-15866: output... (3 Replies)
Discussion started by: Diya123
3 Replies

9. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever... (2 Replies)
Discussion started by: Mannu2525
2 Replies

10. Shell Programming and Scripting

Merge multiple files with common header

Hi all, Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),, How can I merge them to one singe file "X" in shell scripting Thanks for your suggestions. (2 Replies)
Discussion started by: msarguru
2 Replies

LEARN ABOUT DEBIAN

hdfls

HDFLS(1)						      General Commands Manual							  HDFLS(1)

NAME

       hdfls - list basic information about an HDF file

SYNOPSIS

       hdfls [-o] [-l] [-d] [-v] [-g] [-s] [-h] [-t n] hdf_file

DESCRIPTION

       hdfls provides general information about the tags, reference numbers, and if requested, lengths of the data elements.

OPTIONS

       -o     display the reference numbers in ascending order.

       -l     long format.  Display more information about the file.

       -d     Display offset and length information for each element in the file.

       -v     verbose.	Display annotation and label text, along with the format triggered by the -l flag.

       -g     Group.  List items by group.

       -s     Special elements.  Display detailed information about special elements.

       -d     Display offset and length information for each element in the file.

       -h     Dump DD block information.

       -t n   Tag.  Only list information about the specified tag. Must be followed by a tag number.

EXAMPLES

       A  file called "aa.hdf" contains three items associated with a raster image; the image dimensions, a palette, and the raster image. To dis-
       play information about the contents of this file, the following command is used.

       hdfls aa.hdf

       The following output is displayed:

	       aa.hdf:

       Image Dimensions-8:		       (Raster-8): (tag 200)

	       Ref nos: 1

       Image Palette-8: 		       (Raster-8): (tag 201)

	       Ref nos: 3

       Raster Image-8:		       (Raster-8): (tag 202)

	       Ref nos: 1

       The following displays the same information with the length of each data element:

       hdfls -l aa.hdf

       This would result in the following information being displayed:

	       aa.hdf:

	       Image Dimensions-8:	       (Raster-8)      : (tag 200)

	       Ref no 1 	       4 bytes

	       Image Palette-8: 	       (Raster-8)      : (tag 201)

	       Ref no 3 	       768 bytes

	       Raster Image-8:	       (Raster-8)      : (tag 202)

	       Ref no 1 	       120000 bytes

SEE ALSO

       hdf(5)

								 October 31, 1999							  HDFLS(1)
All times are GMT -4. The time now is 02:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy