UNIX for Dummies Questions & Answers

I have a space delimited text file where I want to replace all cells that are 0 with NA. However I cannot simply use 'sed/0/NA/g' because there are other 0's in the text file that are part of numbers.

Example input:
896.933464285715
0
874.691732142857
866.404660714286

Output:
896.933464285715
NA
874.691732142857
866.404660714286

How do I go about doing that? Thanks!

If they're all single lines, just pin the 0 with ^ and $ so it can't find it in the middle of anything else.

Code:

sed 's/^0$/na/'

---------- Post updated at 04:44 PM ---------- Previous update was at 04:42 PM ----------

For multiple columns:

Code:

awk '{ for(N=1; N<=NF; N++) if($N == "0") $N="NA"} 1' inputfile > outputfile