Please correct my English.

The lemming formerly known as:

  • 0 Posts
  • 30 Comments
Joined 1 year ago
Cake day: December 31st, 2024
  • SatyrSack@lemmy.sdf.orgtoTechnology@lemmy.world•*Permanently Deleted*English
    1·
    5 months ago

    Does anyone have any go-to resources to help with scripting LibreOffice Calc? I do not need to convert Excel/VBA scripts for use with LibreOffice; I am fine writing things from scratch. But learning VBA at work was incredibly easy because I could just do a generic Internet search for what I want to do, and there would be a dozen different help posts and articles with detailed explanations and exact code to solve the problem with VBA. But on the LibreOffice Calc side, I cannot find much useful information, for either BASIC or Python.

  • SatyrSack@lemmy.sdf.orgtoProgrammer Humor@programming.dev•The design is very human
    23·
    5 months ago

    Here is my cheatsheet that has been very helpful. Obviously, this will not teach you how RegEx works, but is a good quick reference when I forget the exact syntax for something.

    RegExp

    Character classes

    Pattern Description
    . Any character, except newline
    \w Word
    \d Digit
    \s Whitespace
    \W Not word
    \D Not digit
    \S Not whitespace
    [abc] Any of a, b, or c
    [a-e] Characters between a and e
    [1-9] Digit between 1 and 9
    [[:print:]] Any printable character including spaces
    [^abc] Any character except a, b or c

    Anchors

    Pattern Description
    \G Start of match
    ^ Start of string *
    $ End of string *
    \A Start of string
    \Z End of string
    \z Absolute end of string
    \b A word boundary
    \B Non-word boundary
    ^abc Start with abc
    abc$ End with abc

    For multiline patterns (m flag), ^ and $ will act as start and end of line.

    Escaped characters

    Pattern Description
    \. \* \\ Escape special character used by regex
    \t Tab
    \n Newline
    \r Carriage return

    Groups

    Pattern Description
    (abc) Capture group
    (a|b) Match a or b
    (?:abc) Match abc, but don’t capture
    \1 Substituted with text matched of the 1st capturing group

    Quantifiers

    Pattern Description
    a* Match 0 or more
    a+ Match 1 or more
    a? Match 0 or 1
    a{5} Match exactly 5
    a{,3} Match up to 3
    a{3,} Match 3 or more
    a{1,3} Match between 1 and 3

    Lookahead & Lookbehind

    Pattern Description
    a(?=b) Match a in baby but not in bay
    a(?!b) Match a in Stan but not in Stab
    (?<=a)b Match b in crabs but not in cribs
    (?<!a)b Match b in fib but not in fab
    (?<![a-z])abc(?![a-z]) Match abc without any letters before/after
    Raw Markdown 
    # RegExp

## Character classes

| Pattern       | Description                              |
| ------------- | ---------------------------------------- |
| `.`           | Any character, except newline            |
| `\w`          | Word                                     |
| `\d`          | Digit                                    |
| `\s`          | Whitespace                               |
| `\W`          | Not word                                 |
| `\D`          | Not digit                                |
| `\S`          | Not whitespace                           |
| `[abc]`       | Any of a, b, or c                        |
| `[a-e]`       | Characters between `a` and `e`           |
| `[1-9]`       | Digit between `1` and `9`                |
| `[[:print:]]` | Any printable character including spaces |
| `[^abc]`      | Any character except `a`, `b` or `c`     |

## Anchors

| Pattern | Description            |
| ------- | ---------------------- |
| `\G`    | Start of match         |
| `^`     | Start of string \*     |
| `$`     | End of string \*       |
| `\A`    | Start of string        |
| `\Z`    | End of string          |
| `\z`    | Absolute end of string |
| `\b`    | A word boundary        |
| `\B`    | Non-word boundary      |
| `^abc`  | Start with `abc`       |
| `abc$`  | End with `abc`         |

For multiline patterns (`m` flag), `^` and `$` will act as start and end of line.

## Escaped characters

| Pattern    | Description                            |
| ---------- | -------------------------------------- |
| `\. \* \\` | Escape special character used by regex |
| `\t`       | Tab                                    |
| `\n`       | Newline                                |
| `\r`       | Carriage return                        |

## Groups

| Pattern   | Description                                              |
| --------- | -------------------------------------------------------- |
| `(abc)`   | Capture group                                            |
| `(a\|b)`  | Match `a` or `b`                                         |
| `(?:abc)` | Match `abc`, but don't capture                           |
| `\1`      | Substituted with text matched of the 1st capturing group |


## Quantifiers

| Pattern  | Description           |
| -------- | --------------------- |
| `a*`     | Match 0 or more       |
| `a+`     | Match 1 or more       |
| `a?`     | Match 0 or 1          |
| `a{5}`   | Match exactly 5       |
| `a{,3}`  | Match up to 3         |
| `a{3,}`  | Match 3 or more       |
| `a{1,3}` | Match between 1 and 3 |

## Lookahead & Lookbehind

| Pattern                  | Description                                  |
| ---                      | ---                                          |
| `a(?=b)`                 | Match `a` in `baby` but not in `bay`         |
| `a(?!b)`                 | Match `a` in `Stan` but not in `Stab`        |
| `(?<=a)b`                | Match `b` in `crabs` but not in `cribs`      |
| `(?<!a)b`                | Match `b` in `fib` but not in `fab`          |
| `(?<![a-z])abc(?![a-z])` | Match `abc` without any letters before/after |
  • SatyrSack@lemmy.sdf.orgtoLinux@lemmy.ml•Plasma on AerynOS is finally here!
    8·
    5 months ago

    And nope, not named after the Farscape character…

    https://aerynos.com/blog/2025/02/14/evolve-this-os/

    Pronounced like “Erin”, it’s a name that we feel is more befitting of the project. Pulling from multiple etymologies, it’s a name that better describes the project now versus the project that started as Serpent OS.

    “Aer” is rather obvious, Latin in origin. The phonetic “Erin” is a nod to the Irish roots of the project, and of course a home. There are a number of reasons for the name, which will form part of the initial documentation on the new website.

    Our intent is to have a name that is more inviting, and more descriptive of the project’s goals and aspirations. We’re not anti-establishment or anti-corporation - if anything, we’re a statement that without the fiscal handcuffs, we can produce a technically sound and user-friendly operating system.

    https://aerynos.dev/aerynos/faq/

    What does AerynOS mean and how do I pronounce it?

    AerynOS is a stylised spelling of “Erin”, alluding to the project’s Irish roots. It is pronounced exactly the same as “Erin” - “AIR-in” OS. It’s also a play on “aer” and the phonetic “air” sound, indicative of our desire to produce an open, trusted and high-performance operating system.

    It’s pronounced as “AIR-in” OS.