[Libreoffice-bugs] [Bug 129613] NEW FORMAT:Some characters with the any symbol

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=129613

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Your input of BC1123DIR190X is of type Text, hence only the @ format code is
applicable. This could work with prefix or suffix literal text like
"prefix "@
or
@" suffix"
but nothing else, no interspersed "display masks" (or whatever one would call
that).

You could use the REGEX() function to transform cell content like

  =REGEX("BC1123DIR190X";"(.{6})(..)(.)(\d+)(.*)";"$1-$2-$3-$4-$5")

to "BC1123-DI-R-190-X", or any other exact match.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200302/4425e311/attachment.htm>