Insert a header record (tab delimited) in multiple files Post: 302874605

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple commands TAB delimited

Hey guys... Running Solaris 5.6, trying to write an easy /sbin/sh script. I want to run several commands, then have the results appear on one line. Additionally, I want the results to be separated by <TAB>. Let's say that my script calls three commands (date, pwd, and hostname), I would want...

2. Shell Programming and Scripting

Working with Tab-Delimited files

I have a tab-Delimited file: Eg: 'test' file contains: a<tab>b<tab>c<tab>.... Based on certain condition, I wanna increase the number of lines of this file.How do I do that Eg: If some value in the database is 1 then one line in 'test' file is fine.. If some value in the database is 2...

3. Shell Programming and Scripting

insert a field into a tab delimited file

Hello, Can someone help me to do this with awk or sed? I have a file with multiple lines, each line has many fields separated with a tab. I would like to add one more field holding 'na' in between the first and second fields. old file looks like, 1, field1 field2 field3 ... 2, field1...

4. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Hello, I have about 100 files in a directory with fields which are tab delimited. I would like to append the file name as the first field and it has to be done as many times as the total lines in the file. For example, myFile1.txt has the following data: 1 x y z 2 a b ...

5. UNIX for Dummies Questions & Answers

Delete header row and reformat from tab delimited to fixed width

Hello gurus, I have a file in a tab delimited format and a header row. I need a code to delete the header in the file, and convert the file to a fixed width format, with all the columns aligned. Below is a sample of the file:...

6. Shell Programming and Scripting

[Solved] Append an header to a tab delimited file

Dear All, I would like to find an automatic way to add a given code which belong to a class at the end of the column , for example this is my input file: 0610009O20Rik V$VMYB_01 310 (+) 1 0.971 v-Myb V$EVI1_04 782 (-) 0.763 0.834 Evi-1 V$ELK1_02 1966 (-) 1 0.984 Elk-1...

7. 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 ...

8. 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...

9. Shell Programming and Scripting

Merge multiple tab delimited files with index checking

Hello, I have 40 data files where the first three columns are the same (in theory) and the 4th column is different. Here is an example of three files, file 2: A_f0_r179_pred.txt Id Group Name E0 1 V N(,)'1 0.2904 2 V N(,)'2 0.3180 3 V N(,)'3 0.3277 4 V N(,)'4 0.3675 5 V N(,)'5 0.3456 ...

10. UNIX for Beginners Questions & Answers

Match tab-delimited files based on key

I thought I had this figured out but was wrong so am humbly asking for help. The task is to add an additional column to FILE 1 based on records in FILE 2. The key is in COLUMN 1 for FILE 1 and in COLUMN 1 OR COLUMN 2 for FILE 2. I want to add the third column from FILE 2 to the beginning of...

LEARN ABOUT DEBIAN

csv2mipe

CSV2MIPE(1)						User Contributed Perl Documentation					       CSV2MIPE(1)

NAME

       csv2mipe.pl - Generates MIPE file based on 3 tab-delimited files
	 based on MIPE version v1.1
	 arguments: * tab-delimited file with PCR-level data
		    * tab-delimited file with SNP-level data
		    * tab-delimited file with assay-level data

	 Columns in file with PCR-level data:
	   pcr_id
	   pcr_modified (might be multiple, divided by semi-colon ";")
	   pcr_project (might be multiple, divided by semi-colon ";")
	   pcr_researcher (might be multiple, divided by semi-colon ";")
	   pcr_species
	   source_type
	   source_id
	   design_seq
	   primer1_oligo
	   primer1_seq
	   primer1_tm
	   primer2_oligo
	   primer2_seq
	   primer2_tm
	   design_remark (might be multiple, divided by semi-colon ";")
	   use_seq
	   use_revcomp
	   use_remark (might be multiple, divided by semi-colon ";")
	   pcr_remark (might be multiple, divided by semi-colon ";")

	 Columns in file with SNP-level data:
	   pcr_id
	   snp_id
	   snp_pos
	   snp_amb
	   snp_remark (might be multiple, divided by semi-colon ";")

	 Columns in file with assay-level data:
	   pcr_id
	   snp_id
	   assay_id
	   assay_type
	   assay_enzyme
	   assay_oligo
	   assay_specific
	   assay_tail
	   assay_strand
	   assay_remark (might be multiple, divided by semi-colon ";")

SYNOPSIS

       csv2mipe.pl <pcr_file.csv> <snp_file.csv> <assay_file.csv>

ADDITIONAL INFO

       See http://mipe.sourceforge.net

AUTHOR

       Jan Aerts (jan.aerts@bbsrc.ac.uk)

perl v5.14.2							    2005-07-20							       CSV2MIPE(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple commands TAB delimited

Discussion started by: cdunavent

2. Shell Programming and Scripting

Working with Tab-Delimited files

Discussion started by: shiroh_1982

3. Shell Programming and Scripting

insert a field into a tab delimited file

Discussion started by: ssshen

4. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Discussion started by: Gussifinknottle