I have a file with many columns and some empty cells in different columns. I would like to replace the empty cells for NA only in the third column. My file:
1 id1 info 2 otherinfo 3 id2 4 noinfo 5 id3 6 id4 info2
So the output should be:
1 id1 info 2 otherinfo 3 id2 NA 4 noinfo 5 id3 NA 6 id4 info2
I tried this command (Replacing missing value blank space with zero), but it replaced all empty cells. Any suggestions?