How to calculate the Hamming weight of a binary string?
+0
−0
A presently unanswered question on Stack Overflow asks:
Does there exist a popcount function in libreoffice calc?
and clarifies that "I often use BASE(A1;2;8) to show a number in binary".
1 answer
+1
−0
I believe the answer at the moment is "No" but a very simple formula in LibreOffice 5.4.3.2 can achieve the desired result:
=LEN(SUBSTITUTE(B1;0;""))
where B1 contains:
=BASE(A1;2;8)
as valid and A1 contains the number in decimal.
The B1 cell would not be required with this version:
=LEN(SUBSTITUTE(BASE(A1;2;8);0;""))
This converts to binary, strips out the 0s and counts the number of characters left thereafter.
With the appropriate delimiter, should also work at least in Excel, Sheets and OpenOffice Calc.
0 comments
4 comments
@pnuts if all you need is what format the binary string is in, then it's easy enough to say, right? You could easily give an example, such as "10110111" or something, no need to be roundabout and say that it's the result of the BASE function — Moshi 10 months ago
@pnuts ...does that...matter? — Moshi 10 months ago
@pnuts then that should be a clarification in the answer, not the question — Moshi 10 months ago
Unfortunately, the unanswered question was deleted. — Istiak 14 days ago