Delete an entire column from a tab delimited file Post: 302783347

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete parts of a string of character in one given column of a tab delimited file

I would like to remove characters from column 7 so that from an input file looking like this: >HWI-EAS422_12:4:1:69:89 GGTTTAAATATTGCACAAAAGGTATAGAGCGT U0 1 0 0 ref_chr8.fa 6527777 F DD I get something like that in an output file: ...

2. Shell Programming and Scripting

Delete first column in tab-delimited text-file

I have a large text-file with tab-delimited genetic data that looks like: KSC112 KSC234 0 0 1 1 A G C T I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns). Does anyone have an idea how to do this?

3. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks!

4. Shell Programming and Scripting

Using sed on 1st column of tab delimited file

Hi all, I'm new to Unix and work primarily in bioinformatics. I am in need of a script which will allow me to replace "1" with "chr1" in only the first column of a file which looks like such: 1 10327 rs112750067 T C . PASS ASP;RSPOS=10327;...

5. Shell Programming and Scripting

Extract second column tab delimited file

I have a file which looks like this: 73450 articles and news developmental psychology 2006-03-30 16:22:40 1 http://www.usnews.com 73450 articles and news developmental psychology 2006-03-30 16:22:40 2 http://www.apa.org 73450 articles and news developmental psychology 2006-03-30...

6. UNIX for Dummies Questions & Answers

add (append) a column in a tab delimited file

I have a file having the following entries: test1 test2 test3 11 22 33 22 44 66 99 99 44 --- I want to add a column so that the above file becomes: test1 test2 test3 notest 11 22 33 * 22 44 66 * 99 99 44 * --- Thanks

7. Shell Programming and Scripting

Parse tab delimited file, check condition and delete row

I am fairly new to programming and trying to resolve this problem. I have the file like this. CHROM POS REF ALT 10_sample.bam 11_sample.bam 12_sample.bam 13_sample.bam 14_sample.bam 15_sample.bam 16_sample.bam tg93 77 T C T T T T T tg93 79 ...

8. Shell Programming and Scripting

Convert a 3 column tab delimited file to a matrix

Hi all, I have a 3 columns input file like this: CPLX9PC-4943 CPLX9PC-4943 1 CPLX9PC-4943 CpxID123 0 CPLX9PC-4943 CpxID126 0 CPLX9PC-4943 CPLX9PC-5763 0.5 CPLX9PC-4943 CpxID13 0 CPLX9PC-4943 CPLX9PC-6163 0 CPLX9PC-4943 CPLX9PC-6164 0.04...

9. Shell Programming and Scripting

Delete and insert columns in a tab delimited file

Hi all , I have a file having 12 columns tab delimited . I need to read this file and remove the column 3 and column 4 and insert a word in column 3 as "AVIALABLE " Is there a way to do this . I am trying like below Thanks DJ cat $FILENAME|awk -F"\t" '{ print $1 "\t...

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ...

LEARN ABOUT DEBIAN

vcf-isec

VCF-ISEC(1)							   User Commands						       VCF-ISEC(1)

NAME

       vcf-isec - create intersections, unions, complements on bgzipped and tabix indexed VCF or tab-delimited files

SYNOPSIS

       vcf-isec [OPTIONS] file1.vcf file2.vcf ...

DESCRIPTION

       About: Create intersections, unions, complements on bgzipped and tabix indexed VCF or tab-delimited files.

	      Note that lines from all files can be intermixed together on the output, which can yield unexpected results.

OPTIONS

       -C, --chromosomes <list|file>
	      Process the given chromosomes (comma-separated list or one chromosome per line in a file).

       -c, --complement
	      Output positions present in the first file but missing from the other files.

       -d, --debug
	      Debugging information

       -f, --force
	      Continue even if the script complains about differing columns.

       -o, --one-file-only
	      Print only entries from the left-most file. Without -o, all unique positions will be printed.

       -n, --nfiles [+-=]<int>
	      Output positions present in this many (=), this many or more (+), or this many or fewer (-) files.

       -p, --prefix <path>
	      If present, multiple files will be created with all possible isec combinations. (Suitable for Venn Diagram analysis.)

       -t, --tab <chr:pos:file>
	      Tab-delimited file with indexes of chromosome and position columns. (1-based indexes)

       -w, --win <int>
	      In  repetitive  sequences, the same indel can be called at different positions. Consider records this far apart as matching (be it a
	      SNP or an indel).

       -h, -?, --help
	      This help message.

EXAMPLES

	      bgzip file.vcf; tabix -p vcf file.vcf.gz bgzip file.tab; tabix -s 1 -b 2 -e 2 file.tab.gz

vcf-isec 0.1.5							     July 2011							       VCF-ISEC(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete parts of a string of character in one given column of a tab delimited file

Discussion started by: matlavmac

2. Shell Programming and Scripting

Delete first column in tab-delimited text-file

Discussion started by: andmal

3. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

Discussion started by: evelibertine

4. Shell Programming and Scripting

Using sed on 1st column of tab delimited file

Discussion started by: Hkins552