[Libreoffice-bugs] [Bug 113976] Document how to escape double quotes in text functions

[bugzilla-daemon at bugs.documentfoundation.org]

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

Buovjaga <todventtu at suomi24.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |todventtu at suomi24.fi

--- Comment #1 from Buovjaga <todventtu at suomi24.fi> ---
I was unable to achieve this.

According to this: https://wiki.documentfoundation.org/EscapingCharacters we
express a single double quote by 4 double quotes in a row. Apparently this is
the same in Excel.

I also found information that you can use CHAR(34) to express the double quote.

I tried:
=SUBSTITUTE(A1;"CHAR(34)fooCHAR(34)";"bar")

But it just gives me the contents of A1 unchanged.

I get the same result with 5 double quotes in a row:
=SUBSTITUTE(A1;"""""foo""""";"bar")

-- 
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/20171122/1dd496fa/attachment.html>