Adding EMPTY columns to Tab-delimited txt file Post: 302292487

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading columns in tab delimited file

I want to read only one column in "|" delimited file and write that column to a new file. For Ex: Input File 1|abc|324|tt 2|efd|11|cbcb 3||1|fg 4|ert|23|88 Output : I want to read column 3 in diff file. 324 11 1 88 Can anyone give me inputs on this ?

2. UNIX for Dummies Questions & Answers

nth Columns in a Tab delimited file

Hi Can anyone help me to identify the nth field from a Tab delimited file? Thanks Subrat

3. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ...

4. UNIX for Dummies Questions & Answers

Deleting columns from a tab delimited text file?

I have a tab limited text file with 10000+ columns. I want to delete columns 6 through 23, how do I go about doing that? Thanks!

5. UNIX for Dummies Questions & Answers

Removing empty lines at the end of a Tab-delimited file

I'm trying to remove all of the empty lines at the end of a Tab delimited file. They have no data just tabs. I've tried may things, here are a couple: sed /^\t.\t/d File1 > File2 sed /^\t{44}/d File1 > File2 What am I missing?

6. UNIX for Dummies Questions & Answers

How to add a header to a tab delimited .txt file?

Hi, I have a tab delimited document with 18 columns. My file looks like: comp1000201_c0_seq1 comp1000201_c0 337 183.51 0.00 0.00 0.00 0.00 ---NA--- 337 0 0 - comp1000297_c0_seq1 comp1000297_c0 612 458.50 ...

7. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples...

8. Shell Programming and Scripting

Insert empty columns inside a pipe delimited file

Hi All , I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows . My file 1|2|3|4|5|6|7|8|9|10|11 New file ...

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

bp_sreformat

BP_SREFORMAT(1p)					User Contributed Perl Documentation					  BP_SREFORMAT(1p)

NAME

       bpsreformat - convert sequence formats

DESCRIPTION

       This script uses the SeqIO system that allows conversion of sequence formats either sequence data or multiple sequence alignment data.  The
       name comes from the fact that Sean Eddy's program sreformat (part of the HMMER pkg) already does this.  Sean's program tries to guess the
       input formats while in our code we currently require your to specify what the input and output formats are and if the data is from a
       multiple sequence alignment or from straight sequence files.

       Usage:

       bpsreformat -if INFORMAT -of OUTFORMAT -i FILENAME -o output.FORMAT

	 -h/--help	  Print this help

	 -if/--informat   Specify the input format

	 -of/--outformat  Specify the output format

	 -i/--input	  Specify the input file name
			  (to pass in data on STDIN use minus sign as filename)
	 -o/--output	  Specify the output file name
			  (to pass data out on STDOUT use minus sign as filename)

	 --msa		  Specify this is multiple sequence alignment data

	 --special	  Will pass on special parameters to the AlignIO/SeqIO
			  object -- most of these are for Bio::AlignIO objects
			  Comma separated list of the following
			  nointerleaved   -- for phylip,non-interleaved format
			  idlinebreak	  -- for phylip, makes it molphy format
			  percentages	  -- for clustalw, show % id per line

perl v5.14.2							    2012-03-02							  BP_SREFORMAT(1p)