Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add Header to column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add Header to column
# 1  
Old 04-06-2013
Add Header to column
hello,
can someone helpe me on below issue.
i have a list of names and IDs,

HTML Code:
mick   3424
noah   134
samuel 787
jack   434
i want to add a head for both colum using awk or sed or any tool

output
HTML Code:
 
NAME  ID
 
mick   3424
noah   134
samuel 787
jack   434
Thanks,
Sara
# 2  
Old 04-06-2013
Code:
 
awk 'BEGIN {print "NAME   ID"} {print $0}' input.file
NAME   ID
mick   3424
noah   134
samuel 787
jack   434

You can add \n after ID if you need an extra line after the header.
Last edited by mjf; 04-06-2013 at 09:13 AM.. Reason: You can add \n after ID if you need an extra line after the header
This User Gave Thanks to mjf For This Post:
Sara_84
# 3  
Old 04-06-2013
Or use printf and cat
Code:
{ printf "NAME\tID\n\n"; cat inputfile; } > outputfile

This User Gave Thanks to Yoda For This Post:
Sara_84
# 4  
Old 04-06-2013
Interesting:
unlike
Code:
( command; command ) > outline

one needs a trailing semicolon or a new line in
Code:
{ command; command; } > outputfile

# 5  
Old 04-06-2013
@MadeinGermany: this is described here:
Quote:
Grouping Commands

The format for grouping commands is as follows:

(compound-list)
Execute compound-list in a subshell environment; see Shell Execution Environment . Variable assignments and built-in commands that affect the environment shall not remain in effect after the list finishes.
{ compound-list;}
Execute compound-list in the current process environment. The semicolon shown here is an example of a control operator delimiting the } reserved word. Other delimiters are possible, as shown in Shell Grammar ; a <newline> is frequently used.
Shell Command Language: Grouping Commands
This User Gave Thanks to Scrutinizer For This Post:
MadeInGermany
# 6  
Old 04-06-2013
In sh grammar, { and } are reserved words. They can only occur where reserved words are allowed and must be suitably delimited (unlike operators, for example). Aside from the need for a trailing newline, semicolon, or ampersand; there is also a need to separate the opening brace.

The following is not valid:
Code:
{command;}

But the following is:
Code:
{ command;}

Regards,
Alister
This User Gave Thanks to alister For This Post:
MadeInGermany
# 7  
Old 04-06-2013
Code:
$ uname
Linux

Code:
$ sed "1i NAME   ID\n" text
NAME   ID

mick   3424
noah   134
samuel 787
jack   434

This User Gave Thanks to hanson44 For This Post:
Sara_84
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

Convert rows to column and add header

Hi, I need help to convert rows in input file into a table. inputfile 192.98.1 192.98.192.98.17 VVC family Zorro 10 192.98.1 192.98.192.98.17 VVC family Ace 1 192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Discussion started by: redse171
4 Replies

3. UNIX for Dummies Questions & Answers

How can i substitute a header column?

Hi, I have a txt file with multiple columns and i want to substitute the header of the first column. Example: Seq. Name Seq. Length #Hits min. eValue mean Similarity #GOs GOs Enzyme Codes InterProScan comp1000201_c0_seq1 ---NA--- 337 0 0 - comp1000297_c0_seq1 ---NA--- 612 0 0 -... (4 Replies)
Discussion started by: alisrpp
4 Replies

4. Shell Programming and Scripting

Reading column header

Hi, I have some 10 tab delimited flat files, for some files the column header starts from 1st row whereas for some other files the column header starts from row or row 3 or row4 and so on.... Is there any way in UNIX so that we can read the column headers dynamically.' I am new to UNIX, so... (12 Replies)
Discussion started by: kedar_laveti
12 Replies

5. 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 ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

6. UNIX for Dummies Questions & Answers

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

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

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

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

9. Shell Programming and Scripting

getting the column header in the output !

i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ? below the script: ------------------------------------------------------------------------ #!/bin/ksh .... (4 Replies)
Discussion started by: ali560045
4 Replies

10. 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... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
Login or Register to Ask a Question