Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for pnutsâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #277932 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277930 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277930 |
Post edited: |
— | about 4 years ago |
| Comment | Post #277930 |
@Moshi "standing top" means 'in first place' ("standing on top of" is having the list underneath the user). (more) |
— | about 4 years ago |
| Comment | Post #277930 |
@Moshi I have included a summary of what I interpreted to be the original question so I hope no need to click on the `[Q]` - it was only there for attribution. Did you not also suggest expanding other (non-link) `Q`s? What about the grammar? (more) |
— | about 4 years ago |
| Edit | Post #277932 |
Post edited: |
— | about 4 years ago |
| Comment | Post #277930 |
Hi @Moshi. I would not like to have to use the long-form of *question* every single time on a **Q**&A site. Sorry, can't see what grammar you have changed. I'm not sure but I suspect a space between `]` and `(` breaks a link. (more) |
— | about 4 years ago |
| Edit | Post #277930 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277933 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277933 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How to calculate the Hamming weight of a binary string? 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 ver... (more) |
— | about 4 years ago |
| Edit | Post #277932 | Initial revision | — | about 4 years ago |
| Question | — |
How to calculate the Hamming weight of a binary string? 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". (more) |
— | about 4 years ago |
| Edit | Post #277930 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277931 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277931 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277931 |
Post edited: |
— | about 4 years ago |
| Edit | Post #277931 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Count the number of occurrences in a text string Although spreadsheets were never really intended for text processing, I think a formula solution is possible (LibreOffice 5.4.3.2): For the first example above: =(LEN(A1)-LEN(SUBSTITUTE(A1,"XYZ","")))/LEN("XYZ") and for the second example: =(LEN(B1)-LEN(SUBSTITUTE(B1,"Mary","")))/... (more) |
— | about 4 years ago |
| Edit | Post #277930 | Initial revision | — | about 4 years ago |
| Question | — |
Count the number of occurrences in a text string If I have some text in a cell, how can I find the number of times another piece of text appears in it? For example, suppose `A1` contains `Peter Piper picked a peck of pickled peppers.`. `pick` occurs 2 times in this string. What formula can I put in `A2` so that it counts the occurrences of `pick... (more) |
— | about 4 years ago |
| Suggested Edit | Post #277455 |
Suggested edit: [software-practices] as a tag here is just useless noise. [Ref](https://software.codidact.com/questions/277891#comment-3960)) (more) |
helpful | about 4 years ago |
| Edit | Post #277261 | Post edited | — | over 4 years ago |
| Edit | Post #277262 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277262 |
Post edited: |
— | over 4 years ago |
| Suggested Edit | Post #277261 |
Suggested edit: Spelling. (more) |
helpful | over 4 years ago |
| Edit | Post #277262 | Initial revision | — | over 4 years ago |
| Answer | — |
A: Multiple string concatenation in Excel In Office 365 and Excel 2019 there is a TEXTJOIN: =TEXTJOIN(",",,A1:A10) which can be written into the cell where the output is required. Assumes A1:A10 has been populated to suit. (more) |
— | over 4 years ago |
- ← Previous
- 1
- 2
- 3
- Next →