3 Answers
3

Since it's tab-delimited, you are on the right track by splitting on a tab, rather than awk's default of splitting on any whitespace (any combination of spaces, tabs, and possibly other more esoteric types). Once you've done that, you can assign directly to the column you want to change and just print $0 again.