source/text/scalc/01/func_clean.xhp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
  <!--
    * This file is part of the LibreOffice project.
    *
    * This Source Code Form is subject to the terms of the Mozilla Public
    * License, v. 2.0. If a copy of the MPL was not distributed with this
    * file, You can obtain one at http://mozilla.org/MPL/2.0/.
    *
  -->
  <meta>
    <topic id="calcfunc_clean" indexer="include" status="PUBLISH">
      <title id="tit">CLEAN Function</title>
      <filename>/text/scalc/01/func_clean.xhp</filename>
    </topic>
  </meta>
  <body>
    <bookmark branch="index" id="bm_id3149009">
  <bookmark_value>CLEAN function</bookmark_value>
</bookmark>
    <bookmark branch="hid/SC_HID_FUNC_SAEUBERN" id="bm_id3148729" localize="false"/>
    <section id="func_clean">
      <h1 id="hd_id3149009">
        <variable id="clean_h1">
          <link href="text/scalc/01/func_clean.xhp">CLEAN</link>
        </variable>
      </h1>
      <paragraph id="par_id3150482" role="paragraph">
        <ahelp hid="HID_FUNC_SAEUBERN">All non-printing characters are removed from the string.</ahelp>
      </paragraph>
    </section>
    <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
    <paragraph id="par_id3147472" role="code">CLEAN("Text")</paragraph>
    <paragraph id="par_id3150695" role="paragraph"> <emph>Text</emph> refers to the text from which to remove all non-printable characters.</paragraph>
    <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
    <paragraph role="paragraph" id="par_id581621538151600"><input>=LEN(CLEAN(CHAR(7) &amp; "LibreOffice Calc" &amp; CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the beginning and end of the string argument. CLEAN does not remove spaces.</paragraph>
    <section id="relatedtopics">
    <tip id="par_id411677015788900"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/CLEAN">CLEAN wiki page</link>.</tip>
    </section>
  </body>
</helpdocument>