ansaurus

Question

Need help with the Awk substitute command

Answer 1

+1 A:

awk -F "|" {' sub(".*@","",$5); print $5 '} test.log

Missing semicolon after the first statement.

Mech Software 2010-02-09 16:54:46

Thanks MechS, I am still getting an error after trying your command:awk: sub(".*@","",$5); print $5 awk: ^ syntax error

roacha 2010-02-09 17:03:59

awk -F "|" {' sub(".*@","",$5); print $5 '} test.logfrom my linux command line with your sample data yields "SuperFly"Your awk interpreter may be requiring a ; after the last statement tooawk -F "|" {' sub(".*@","",$5); print $5; '} test.logMine did not.

Mech Software 2010-02-09 17:19:03

As an FYI, I generally find it easier to use the -f parameter and edit a file. It's more readable down the road and a lot of editors might have noted the bad syntax.

Mech Software 2010-02-09 17:20:50

Sorry, I don't understand what is happening with my setup. I am running Suse Linux 10. Is there another way to do this via a script? I will need this to run everyday on multiple large files and change this column. Script now:awk -F "|" {' sub(".*@","",$5); print $5; '} test.logSame error:awk: sub(".*@","",$5); print $5; awk: ^ syntax error

roacha 2010-02-09 18:20:51

I have also tried the same script and data on a CentOS 5 system. And I get the same error.

roacha 2010-02-09 18:42:17

Working fine on my ubuntu. Try putting the code {sub(".*@","",$5); print $5;} in a file and running awk with the -f parameter to the .awk file with this code in it. The only other thing I can think of is the single quotes '. I'm not sure why you have those on the inside of the {} braces. Awk treats each set of braces as a rule against input.

Mech Software 2010-02-09 19:13:14

awk -F "|" '{ sub(".*@","",$5); print $5; }' test.log worked fine on CentOS. It was your quotes throwing you off along with other syntax errors.

Mech Software 2010-02-09 19:25:20

Yep, you got it Mech. I just ran it with moving the single quotes outside the {} and it worked like a charm. Thanks for all your help!

roacha 2010-02-09 19:36:51

Answer 2

A:

are you editing the whole file and replacing every line with the value of column 5? if not,

awk -F"|" '$5~/@/{ sub(".*@","",$5) }{print}' OFS="|" file

ghostdog74 2010-02-10 00:40:34

ansaurus

tags:

views:

answers:

Need help with the Awk substitute command

related questions