Sponsored Content
Top Forums Shell Programming and Scripting Insert a header record (tab delimited) in multiple files Post 302874595 by pchang on Friday 15th of November 2013 03:59:47 PM
Old 11-15-2013
Insert a header record (tab delimited) in multiple files

Hi Forum.

I'm struggling to find a solution for the following issue.

I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files.

This is my code so far but it's not working as expected.

Code:
for i in a*.txt; { awk 'BEGIN{print "CIF,"\t",Status,"\t",FirstName,"\t",LastName,"\t",BirthDate,"\t",Address,"\t",City,"\t",Province,"\t",Country,"\t",occupation,"\t",ClientSinceDate TotalBalance"}1' $i > $i.tmp; mv $i.tmp $i; }

Thank you for your help
 

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 Replies)
Discussion started by: cdunavent
2 Replies

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... (1 Reply)
Discussion started by: shiroh_1982
1 Replies

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... (7 Replies)
Discussion started by: ssshen
7 Replies

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 Replies)
Discussion started by: Gussifinknottle
5 Replies

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:... (4 Replies)
Discussion started by: chumsky
4 Replies

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... (4 Replies)
Discussion started by: paolo.kunder
4 Replies

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 ... (1 Reply)
Discussion started by: alisrpp
1 Replies

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... (3 Replies)
Discussion started by: Hypesslearner
3 Replies

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 ... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

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... (8 Replies)
Discussion started by: andmal
8 Replies
WARPTENSORIMAGEMULTITRANSFORM(1)				   User Commands				  WARPTENSORIMAGEMULTITRANSFORM(1)

NAME
WarpTensorImageMultiTransform - part of ANTS registration suite DESCRIPTION
WarpImageMultiTransform ImageDimension moving_image output_image [-R reference_image | --tightest-bounding-box] (--reslice-by-header) [--use-NN (use Nearest Neighbor Interpolator)][--ANTS-prefix prefix-name | --ANTS-prefix-invert prefix-name] {[deformation_field | [-i] affine_transform_txt | --Id | [-i] --moving-image-header / -mh | [-i] --reference-image-header / -rh]} Example: Reslice the image: WarpIm- ageMultiTransform 3 Imov.nii Iout.nii --tightest-bounding-box --reslice-by-header Reslice the image to a reference image: WarpImageMulti- Transform 3 Imov.nii Iout.nii -R Iref.nii --tightest-bounding-box --reslice-by-header Note: -i will use the inversion of the following affine transform. --tightest-bounding-box will be overrided by -R reference_image if given. It computes the tightest bounding box using all the affine transformations. --Id uses the identity transform. --moving-image-header or -mh in short will use the orientation header of the moving image file. This is typically not used with --reslice-by-header. --reference-image-header or -rh in short will use the ori- entation header of the fixed image file. This is typically not used with --reslice-by-header. --reslice-by-header uses the orientation matrix and origin encoded in the image file header. It can be used together with -R. This is typically not used together with any other transforms. --reslice-by-header is equvalient to -i -mh, or -fh -i -mh if used together with -R. For ANTS users: To use with the deformation field and the affine transform files generated from ANTS: --ANTS-prefix prefix-name --ANTS-pre- fix-invert prefix-name Example: 3 moving_image output_image -R reference_image --ANTS-prefix abcd.nii.gz Applies abcdWarpxvec.nii.gz/abcd- Warpyvec.nii.gz/abcdWarpzvec.nii.gz and then abcdAffine.txt. Use this with ANTS to get the moving_image warped into the reference_image domain. 3 reference_image output_image -R moving_image --ANTS-prefix-invert abcd.nii.gz --ANTS-invert Applies the inversion of abcdAffine.txt and then abcdInverseWarpxvec.nii.gz/abcdInverseWarpyvec.nii.gz/abcdInverseWarpzvec.nii.gz. Use this with ANTS to get the reference_image warped into the moving_image domain. Note: prefix name "abcd" without any extension will use ".nii.gz" by default WarpTensorImageMultiTransform 1.9 May 2012 WARPTENSORIMAGEMULTITRANSFORM(1)
All times are GMT -4. The time now is 03:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy