Shell Scripting

Shell Scripting RSS

Adding a new column in a text file

•

Join Date: Mar 2009

Posts: 1

Reputation: snahata is an unknown quantity at this point

Solved Threads: 0

snahata

Offline

Newbie Poster

Adding a new column in a text file

Mar 12th, 2009

Hi,

I would like to add a new column in a text file which contains values based on the value of another column.
Eg:
suppose the text file contains:
1 abc 67
2 def 40
3 uty 57
.......
....
Now i would like to add a new column which contains value 'yes' if the column 3 > 40 else 'no'.
Is it possible using awk ??

•

Join Date: Oct 2008

Posts: 95

Reputation: fpmurphy is an unknown quantity at this point

Solved Threads: 5

fpmurphy

Offline

Junior Poster in Training

Re: Adding a new column in a text file

Mar 15th, 2009

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
$ awk '{ if ($3 > 40) four="yes"; else four="no"; print $0, four }' file
1 abc 67 yes
2 def 40 no
3 uty 57 yes
$
$ awk '{ if ($3 > 40) four="yes"; else four="no"; print $0, four }' file
1 abc 67 yes
2 def 40 no
3 uty 57 yes
$

•

Join Date: Apr 2006

Posts: 148

Reputation: ghostdog74 is on a distinguished road

Solved Threads: 40

ghostdog74 ghostdog74 is offline

Offline

Junior Poster

Re: Adding a new column in a text file

Mar 17th, 2009

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
awk '{printf "%s %s",$0, ($3 > 40)? "yes" :"no"}' file
awk '{printf "%s %s",$0, ($3 > 40)? "yes" :"no"}' file