how to replace dot as 'Missing' value for all columns using sed

Question

[newbiebio]

I tried to replace all the dot as missing value. I tried used sed 's/^./Missing/g' test.txt. There is no change. When used sed 's/.$/Missing/g' test.txt. Only the dot in the last column changed.

ex. col1 col2 col3 . 13.34 12.44 12.3 . 12.22 . 125.5 .

[Rohit]

sed 's/ \./ Missing/g' test.txt

Answer 1

[Tonor]

Assuming your data is space separated:

sed 's/ . / Missing /g' test.txt

[Jorge Amigo]

to be really space/tab independent, the proper way to write it would be

sed 's/\(\s\)\.\(\s\)/\1Missing\2/g' test.txt

unfortunately this won't work with 2 consecutive dot columns, neither with the first and last columns. see my answer below.

[newbiebio]

It's not working. I just tried 'sed 's/./Missing/g' colon.txt', it replaced all the dot, even the dot in '12.44'

[Tonor]

Note the spaces before and after the dot and before and after the Missing

[newbiebio]

Thanks to your advice. I tried the following, it works. sed 's/.\t/Missing\t/g' test.txt

[Tonor]

Is your data space separated? Or tab? What Operating system? You could try instead (spaces inbetween brackets):

sed 's/[ ].[ ]/ Missing /g' test.txt.

Answer 2

[Jorge Amigo]

a sed independent solution on field separators, that would deal with 2 consecutive dot columns plus the first and last columns would be the following

sed 's/\./Missing/g; s/Missing\(\S\)/.\1/g' test.txt

or its perl alternative

perl -pe 's/\./Missing/g; s/Missing(\S)/.$1/g' test.txt

Answer 3

[Biomonika (Noolean)]

sed 's/\./Missing/g' test.txt

[WouterDeCoster]

That will also adapt the decimal separator.