AWK print header row and change field value

I am trying to change the city on all records and keep the header.

What I have:

Name,City,State
Bob,Portland,Oregon
Sue,Portland,Oregon
David,Portland,Oregon

What I want:

Name,City,State
Bob,Bend,Oregon
Sue,Bend,Oregon
David,Bend,Oregon

What I have tried:

awk -F',' 'NR>1 $2 == "Portland" {$2 = "Bend";print}' OFS=","

Any help will be greatly appreciated

1 Answer

Try:

$ awk -F',' 'NR>1 && $2 == "Portland" {$2 = "Bend"} {print}' OFS="," file
Name,City,State
Bob,Bend,Oregon
Sue,Bend,Oregon
David,Bend,Oregon

or, using the usual awk shorthand:

awk -F',' 'NR>1 && $2 == "Portland" {$2 = "Bend"} 1' OFS="," file

Notes:

1. When you have two conditions, like NR>1 and $2 == "Portland" and your want both to apply, they need to be combined with logical-and: &&.

2. You want all lines printed and awk does not print by default. So, we moved the print command to a separate group so it applied to all lines.

Alternative: using sed

Using sed, we can get the same result:

$ sed 's/,Portland,/,Bend,/' file
Name,City,State
Bob,Bend,Oregon
Sue,Bend,Oregon
David,Bend,Oregon