Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add column to end of each line with ´awk´

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add column to end of each line with ´awk´
# 1  
Old 06-06-2014
Add column to end of each line with ´awk´
Hi,
I have data with approximately 300 columns.
I want to add a column to the end of each column with the value "1".
Is there a way that I can do this is ´awk´ without having to specify each individual column.
For instance, my data looks like:
Code:
pvb 1 2 3 4 5 ....... 300
fdh 3 4 5 2 4 ...... 300
dfk 2 3 4 2 6 ...... 300

and I want to add the following value as the last column:
Code:
pvb 1 2 3 4 5 ....... 300 1
fdh 3 4 5 2 4 ...... 300 1
dfk 2 3 4 2 6 ...... 300 1

Is this possible with ´awk´ ??
# 2  
Old 06-06-2014
A few questions:-
  • What have you tried so far?
  • Is awk the only option you will allow?


Robin
# 3  
Old 06-06-2014
I have tried so far the standard
Code:
awk '{print $1.....$300 "\t" "1"}'.

However, I must do this for many and typing "$X" 300 times seemed unnecessary.
So, I wanted to learn if there is a way to put this information, as each line is uniform, in the last line automatically?
No, ´awk´ is not the only option I will allow for, I just thought in this case ´awk´ seemed to make the most sense Smilie
# 4  
Old 06-06-2014
Try
Code:
awk '{$(NF+1)=1}1' file
pvb 1 2 3 4 5 ....... 300 1
fdh 3 4 5 2 4 ...... 300 1
dfk 2 3 4 2 6 ...... 300 1

This User Gave Thanks to RudiC For This Post:
owwow14
# 5  
Old 06-06-2014
Try using $0 instead:-
Code:
awk '{print $0 "\t" "1"}' file


Does that give you what you need?


Robin
This User Gave Thanks to rbatte1 For This Post:
owwow14
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Printing string from last field of the nth line of file to start (or end) of each line (awk I think)

My file (the output of an experiment) starts off looking like this, _____________________________________________________________ Subjects incorporated to date: 001 Data file started on machine PKSHS260-05CP ********************************************************************** Subject 1,... (9 Replies)
Discussion started by: samonl
9 Replies

2. Shell Programming and Scripting

To append new data at the end of each line based on substring of last column

Hi guys, I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column. Input file xxx.csv: U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0 U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0... (5 Replies)
Discussion started by: null7
5 Replies

3. Shell Programming and Scripting

Conversion if 1st column is match (awk '{s+=$1} END

Hi im trying to add numbers, got no problem with it im using awk '{s+=$1} END {print s, "MB"}', but what if the numbers are like mention below. who will i add them 2000 KB 1 MB Answer: 2001 Desired: 2000 KB 1 MB Answer: 3000 (4 Replies)
Discussion started by: invinzin21
4 Replies

4. Shell Programming and Scripting

Add line at the end

How to add a comma at the end of each line in this file?30 1412 30 3352 30 5254 30 5543 30 7478 3 28 3 30 3 39 3 54 3 108 3 152 3 178 3 182 3 214 3 271 3 286 3 300 3 348 3 349 3 371 (3 Replies)
Discussion started by: gunjan
3 Replies

5. UNIX for Dummies Questions & Answers

delete trailing whitespace from end of each line in column 1 only

Hi All. How can I convert this: ABC_1_1 ABC_1_2 ABC_1_3 into this: ABC_1 1 ABC_1 2 ABC_1 3 I tried this command but it is not working: awk '{sub(/+$/,"\t", $1)}{print}' Any suggestions on how to fix this? Thank you :wall: Please use code tags when posting data and... (3 Replies)
Discussion started by: danieladna
3 Replies

6. Shell Programming and Scripting

Get the 1st 99 characters and add new line feed at the end of the line

I have a file with varying record length in it. I need to reformat this file so that each line will have a length of 100 characters (99 characters + the line feed). AU * A01 EXPENSE 6990370000 CWF SUBC TRAVEL & MISC MY * A02 RESALE 6990788000 Y... (3 Replies)
Discussion started by: udelalv
3 Replies

7. Shell Programming and Scripting

how to add ; at the end of last line

hi, i have file which is having large sql query eg : i am executing this sql file but now i want to add ; after query on same line i.e. i should look like any idea how to achieve it ? (6 Replies)
Discussion started by: crackthehit007
6 Replies

8. UNIX for Advanced & Expert Users

Add line numbers to end of each line

Hi i would like to add line numbers to end of each line in a file. I am able to do it in the front of each line using sed, but not able to add at the end of the file. Can anyone suggest The following code adds line number to start of each line sed = filename | sed 'N;s/\n/\t/' how can i... (5 Replies)
Discussion started by: rudoraj
5 Replies

9. Shell Programming and Scripting

Add a new end of line

Hi, Does anyone know if its possible to add something like an end of line like c or java in unix? dirs=/home/nosnam var='' for dir in $dirs do listDirs=`ls -d1 $dir/*` for eachList in $listDirs do listRepos=`du -ks $eachList | awk '{ x+=$1 }; END { print x... (4 Replies)
Discussion started by: nosnam
4 Replies

10. HP-UX

Add a column at the end of all the lines in a file

Hi Guys, :D I am very much new to UNIX. I dont have much basics of coding in UNIX, so please help me out of thi ssituation. I have a file say for ex: ABC.dtd and it contains "|" delimited data as test1|testing|test3|moving past1|runing|test4|going I need to add a column at the end... (6 Replies)
Discussion started by: ruthless
6 Replies
Login or Register to Ask a Question