Below you will find pages that utilize the taxonomy term “awk”
Blog
Replace Entire Column with a Number in Bash
Use below awk one-liner to replace all values in a column (5th column in example) with a value (1 in example).
awk "{$5=1} {print}" filename > filename.replaced