https://bugs.documentfoundation.org/show_bug.cgi?id=109003
Heiko Tietze <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Heiko Tietze <[email protected]> ---
Example 1
=LEFT(A1,FIND(" ",A1)-1)
Example 2
=MID(A2,SEARCH(" [^ ]*$",A2,1)+1,1) & "." (RegEx has to be enabled in Tools >
Options; splitting names is always a tricky task and you likely fail like in
this example)
Example 3
Either use Find() repeatedly parametrized with the first occurrence of the
underscore or Search(). It's not completely clear if the string may contain
more than two underscores.
What I want to demonstrate is that Calc has powerful methods to do what you
want without automatic processing. The request is not defined precise enough to
get implemented. My take: WORKSFORME. May Q decide.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
