https://bugs.documentfoundation.org/show_bug.cgi?id=118505
--- Comment #4 from Maciej KotliĆski <mk...@ibb.waw.pl> ---
Actually I've got this problem when striping the last digit (and possibly a
character) from the name names of samples from some analyses.
I've got such names as in first column and would like to strip last digit and
possibly letter. I was surprised to get different results for "KHe3r" and
"KHe3" when using "[0-9]?$". One can deal with the problem with
"[0-9][a-z]{0,1}$" which work as I expected.
=SZUKAJ.TEKST(REGEX; AX)
"[0-9]?$" stripped text* "[0-9][a-z]{0,1}$" stripped text*
K-7dpi3 7 K-7dpi 7 K-7dpi
KHe1 4 KHe 4 KHe
KHe2s 6 KHe2s 4 KHe
KHe3 4 KHe 4 KHe
KHe3r 6 KHe3r 4 KHe
KL101a 7 KL101a 5 KL10
KL102 5 KL10 5 KL10
KL103 5 KL10 5 KL10
KL10-3dpi1 10 KL10-3dpi 10 KL10-3dpi
KL10-3dpi2 10 KL10-3dpi 10 KL10-3dpi
MM-10dpi1 9 MM-10dpi 9 MM-10dpi
*stripped text returned by =FRAGMENT.TEKSTU(A1; 1; [result from the coulumn
with position]-1)
Thank you for clarifying the problem. I describe the solution which works for
me. Maybe it will be helpful for somebody.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs