Adding a new column in a text file

Expand Post »

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 ??

Similar Threads

Help regarding images in datagridview in C#
Adding a new row in a Datagrid ??????????? in C#
insert csv file into mysql through php in PHP
reading, modifying data within .csv file in C++
Incompatible Types? in Java

snahata

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2009

Permalink

Mar 15th, 2009

Re: Adding a new column in a text file

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
$

fpmurphy

Reputation Points: 22

Solved Threads: 11

Junior Poster

Offline

144 posts
since Oct 2008

Permalink

Mar 17th, 2009

Re: Adding a new column in a text file

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

ghostdog74

Reputation Points: 75

Solved Threads: 44

Junior Poster

Offline

156 posts
since Apr 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Shell Scripting Forum Timeline: using grep, sed, awk to pull links out of an XML file

Next Thread in Shell Scripting Forum Timeline: More Graphical screens

DaniWeb Message

Cancel Changes

User Name
Password