erAck on Nostr: Because the empty match is the first match for any "zero or more" pattern if the ...
Because the empty match is the first match for any "zero or more" pattern if the string does not start with it (and it's not a blank but an empty string). It's the same for the pattern 'x*' and this ">335" string. The second possible match for '[0-9]*' is 335. If you want it to match only the digits then instead use '[0-9]+', or restrict match to the second occurrence, like
=REGEX(">335";"[0-9]*";;2)
'[0-9]{1,3}' matches one to three digits, as many times as possible.
Published at
2025-01-14 20:13:25Event JSON
{
"id": "932f382b881486bf4ccada52bc3cd5b4230557177027e290d764ff2980f37ddd",
"pubkey": "fdea06dc40dab773a41dc6851a211cfe5917d92b9ebd287777029c38c4f7fe76",
"created_at": 1736885605,
"kind": 1,
"tags": [
[
"proxy",
"https://social.tchncs.de/@erAck/113828535063778987",
"web"
],
[
"e",
"53f4842f1d21cf6853f6a0310ae508bbb7ad0b36189a9b68250b476ad6945c50",
"",
"root",
"14965443867d679e8aefaf4b76d6af788bf00e8b2dcff9cbe51a110f2ba4c6e7"
],
[
"p",
"14965443867d679e8aefaf4b76d6af788bf00e8b2dcff9cbe51a110f2ba4c6e7"
],
[
"proxy",
"https://social.tchncs.de/users/erAck/statuses/113828535063778987",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://social.tchncs.de/users/erAck/statuses/113828535063778987",
"pink.momostr"
],
[
"-"
]
],
"content": "Because the empty match is the first match for any \"zero or more\" pattern if the string does not start with it (and it's not a blank but an empty string). It's the same for the pattern 'x*' and this \"\u003e335\" string. The second possible match for '[0-9]*' is 335. If you want it to match only the digits then instead use '[0-9]+', or restrict match to the second occurrence, like\n\n=REGEX(\"\u003e335\";\"[0-9]*\";;2)\n\n'[0-9]{1,3}' matches one to three digits, as many times as possible.",
"sig": "c4991c117f5c932653157b498907b7ac65cc0354d63203958718b1805f74d0e46805bc72e970f91439cb8de74a282bb3b2a4745128e325a4eebb8d2f169c0319"
}