Unix/Linux Go Back    

Shell Programming and Scripting BSD, Linux, and UNIX shell scripting Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Quick sed/awk question

Shell Programming and Scripting

awk, question, sed

Thread Tools Search this Thread Display Modes
Old Unix and Linux 12-10-2012
lucshi09 lucshi09 is offline
Registered User
Join Date: Jul 2012
Last Activity: 22 November 2013, 7:33 PM EST
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
Quick sed/awk question

Hi fellow linux-ers,

I have a quick question for you. I have the following text, which I would like to modify:

10 121E(121) 16 Jan
34S 132E 24 Feb
42 176E(176) 18 Sep
21S 164E 25 May
15 171W(-171) 09 Jul

How can I do the following 2 modifications using sed and/or awk?
1. in 1st column, if a field has an "S", delete the "S" and add a "-" in front of number
2. in the 2nd column, delete the parenthesis and the number that exists within it

Moderator's Comments:
Quick sed/awk question code tags please
Sponsored Links
Old Unix and Linux 12-10-2012
rdrtx1 rdrtx1 is offline
Registered User
Join Date: Sep 2012
Last Activity: 26 October 2016, 8:27 PM EDT
Location: Houston, Texas, USA
Posts: 862
Thanks: 0
Thanked 295 Times in 282 Posts

awk '$1 ~ /S/ {gsub("S","",$1);$1="-"$1} {sub("[(].*[)]","",$2)} 1' infile

The Following User Says Thank You to rdrtx1 For This Useful Post:
lucshi09 (12-10-2012)
Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Quick Sed Question eo29 Shell Programming and Scripting 6 09-26-2011 08:28 AM
Quick Question on sed command in shell script luft Shell Programming and Scripting 4 09-10-2008 05:36 PM
Help with AWK -- quick question Probos Shell Programming and Scripting 5 07-18-2007 04:26 PM
quick sed question vbm Shell Programming and Scripting 2 11-09-2006 09:44 PM
a quick SED question hcclnoodles Shell Programming and Scripting 1 09-22-2006 10:54 AM

All times are GMT -4. The time now is 08:46 AM.