How can i substitute a header column? Post: 302808909

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex...

2. Shell Programming and Scripting

Column header

Hello all, We are trying to run a script in Oracle DB from AIX. We need to set the Column Header while executing the query to generate the Output. For eg. select city, name from emp; It need to generate report in .csv format as CITY NAME atla tom cincin jack How I...

3. Shell Programming and Scripting

using awk to substitute data in a column delimited text file

using awk to substitute data in a column delimited text file hello i would like to use awk to do the following calculation from the following snippet. input file C;2390 ;CV BOUILLOTTE 2L 2FACES NERVUREES ;1.00 ;3552612239004;13417 ;25 ;50 ; 12;50000 ; ; ...

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256...

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

6. Shell Programming and Scripting

substitute in first column

Hi, I have a file which has multiple columns in and i want to replace first column with : in between them. input_file 21000012343456 asdf 21000012343478 asd3 21000012343423 asdf 21000012343445 asdf 21000012343489 asdf output file 21:00:00:12:34:34:56 asdf 21:00:00:12:34:34:78 asd3...

7. Shell Programming and Scripting

awk to substitute third column if first column is greater than interest

A file 2400 2800 PSC000289 3200 3896 PCS000289 3333 3666 PCS000221 222 1000 PCS000222 3299 3600 PSC000289 Question is while if third column is PCS000289 and first column should be greater than 3000, then replace PCS000289 by YES, remaining the others column same. ...

8. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ...

9. UNIX for Dummies Questions & Answers

Substitute first column based on second column

Hi, I have files with lines that look like HSQ1008:141:D0CC8ACXX:3:1106:17255:124378 163 chr14 I'm wondering how I can output a file that appends /1 if the second column is 99 or 83 and a /2 if the second column is 163 or 147. Also I want to put \n + \n between each the second...

10. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70...

LEARN ABOUT DEBIAN

gethead

gethead(1)						      General Commands Manual							gethead(1)

Name
       gethead - Print FITS or IRAF header keyword values

Synopsis
       gethead [-hptv] [-d pathname] [-n num] <FITS or IRAF file> kw1 kw2 ... kwn

Description
       Print  values of the specified keywords from the given image header.  By default they are all listed on one line, separated by spaces.  The
       -v flag causes the keyword names and values to be printed, one keyword per line.  To read keywords from a list of files, substitute @<list-
       file>  for  the file names on the command line.	To read a lot of keywords, put them, one per line, in a file and substitute @<keylistfile>
       on the command line.  If two @ commands are present, the program will figure out which contains file names and which contains keywords.

Options
       -a     List file name even if keywords are not found

       -d     Root directory for input files (default is cwd)

       -e     Output keyword=value's on one line per file

       -f     Never print filenames (default is to print them if more than one)

       -g     Output keyword=value's on one line per keyword

       -h     flag causes the keyword names to be printed at top of columns.

       -n     Number of decimal places in numeric output

       -o     OR conditions instead of ANDing them

       -p     Print full pathnames of files

       -t     flag causes the output to be in tab-separated tables with keyword column headings.

       -u     Always print ___ if keyword not found, event if only one keyword in search

       -v     Print output as <keyword>=<value>, one per line

Web Page
       http://tdc-www.harvard.edu/software/wcstools/gethead.html

Author
       Doug Mink, SAO (dmink@cfa.harvard.edu)

6 July 2001							     WCSTools								gethead(1)