Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| replace a field in a CSV file | prvnrk | Shell Programming and Scripting | 2 | 11-12-2008 08:51 AM |
| replace single field out of 60 | ajp7701 | Shell Programming and Scripting | 2 | 04-21-2008 07:17 PM |
| Replace field in csv | pcboss | Linux | 4 | 01-19-2008 06:24 PM |
| Replace password field using ed/sed | munch | UNIX for Dummies Questions & Answers | 6 | 04-30-2007 11:01 PM |
| Replace 10th Field by 2 | PradeepRed | Shell Programming and Scripting | 2 | 01-19-2006 03:46 AM |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
06-03-2009
|
||||
|
||||
|
awk to replace particular field
i have bad data for instance, the use of capital letters in the middle of the word.
I identified the errors, made a list and put it in a file error_correction.txt Incorrect,Correct VeNOM,Venom nos,NOS . . . My data file looks like this: vgr,bugatti veron,,3.5,Venom,6,.......,.... vgr,lamborgini,,3.5,nos,6,.......,.... abc,bugatti veron,,3.5,Venom,6,.......,....... . . . . I need to replace the terms in a the 5th field with that from the file. How do i do this using awk?? |
|
06-03-2009
|
|||||
|
|||||
An example to get you started...
Code:
> echo "867 5309 VerNOM 1234 Abcd"
867 5309 VerNOM 1234 Abcd
> echo "867 5309 VerNOM 1234 Abcd" | awk -v v1="VerNOM" -v v2="Vernom" '{gsub(v1,v2,$3);print}'
867 5309 Vernom 1234 Abcd
|
|
06-04-2009
|
||||
|
||||
|
Try this:
Code:
awk -F, '
NR==FNR{a[$1]=$2;next}
a[$5]{$5=a[$5]}
1' error_correction.txt datafile
|
|
06-04-2009
|
||||
|
||||
|
The file is can not be edited "in place" with awk. Redirect the output to a temporary file and replace the original file with it.
Code:
awk '<commands>' error_correction.txt datafile > tempfile mv tempfile datafile |
|
06-04-2009
|
||||
|
||||
|
cool...
awesome stuff thanks a ton man.... |
| Sponsored Links | ||
|
|
Linear Mode
