this post was submitted on 27 Dec 2023
88 points (95.8% liked)

Linux

48655 readers
953 users here now

From Wikipedia, the free encyclopedia

Linux is a family of open source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991 by Linus Torvalds. Linux is typically packaged in a Linux distribution (or distro for short).

Distributions include the Linux kernel and supporting system software and libraries, many of which are provided by the GNU Project. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses the name GNU/Linux to emphasize the importance of GNU software, causing some controversy.

Rules

Related Communities

Community icon by Alpár-Etele Méder, licensed under CC BY 3.0

founded 5 years ago
MODERATORS
 

Short term: I'm trying to automate transcribing a list from:
A
123
234
B
456
567
789
C
345

Into an array/table
123, A
234, A
456, B
567, B
789, B
345, C

Long term answer I'm looking for: where's a lemmy community I can ask questions like this (like about using formulas in Librecalc/Onlyoffice suite/maybe VBA with them too) in the future?

Or, if not yet established on lemmy, recommended librecalc/Onlyoffice forums?

Thank you for your time.

you are viewing a single comment's thread
view the rest of the comments
[–] Donovar 4 points 1 year ago* (last edited 1 year ago) (10 children)

Are the numeric values always correctly sorted in the cells below the alpha data cells? IE, youd never have A numeric values, then B numeric values, then more A numeric values?

Also just to be clear, are you putting the results in a single cell, or does the comma in your example denote separation between two cells? I'm guessing two cells. I want to work on this, but I just want to make sure I'm working on the correct thing :)

[–] BlindFrog 2 points 1 year ago (2 children)

To clarify the first, yes to your example, I think so. I'm trying to optimize my scanning process, so, optimally, yes, I would only record all A numeric values in one go, and not come back to them again for the rest of the list. Good question; I never thought about this as a complication. So, I have shelves among shelves with a strict naming convention and containers with a different naming convention. I'm figuring out how to help me and my family be lazier and just capture the shelf name, then all the stuff there, then move on to the next place.

To clarify the second concern, yeah, I meant to make the comma denote two separate cells. I'm not sure how to make a table on lemmy through the Boost app.

[–] Donovar 2 points 1 year ago* (last edited 1 year ago)

Actually, shoot... After rereading your reply, I might have taken your example data too literally. Are the alpha values truly always alpha and your numeric values always numeric? Otherwise it won't work, and I'll have to find another solution.

load more comments (1 replies)
load more comments (8 replies)