tdf#143846 split CHAR + CLEAN. + helper

to extract xhp files, run :
perl helpers/calc_text_func.pl CHAR CLEAN
ouput :
TODO. add to git and  AllLangHelp_scalc.mk :
helpcontent2/source/text/scalc/01/func_char \
helpcontent2/source/text/scalc/01/func_clean \


Change-Id: I986cb038748586c12bd09441070cf272de2d4106
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174677
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

3 files changed, 79 insertions, 38 deletions

diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 9b56a621df..71276ba4b8 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -98,44 +98,9 @@
   <embed href="text/scalc/01/func_base.xhp#func_base"/>
 </section>
 
-<section id="char">
-<bookmark branch="index" id="bm_id3149321">
-  <bookmark_value>CHAR function</bookmark_value>
-</bookmark>
-
-<bookmark branch="hid/SC_HID_FUNC_ZEICHEN" id="bm_id3159128" localize="false"/>
-
-<h2 id="hd_id3149321">CHAR</h2>
-<paragraph id="par_id3149150" role="paragraph"><ahelp hid="HID_FUNC_ZEICHEN">Converts a number into a character according to the current code table.</ahelp> The number can be a two-digit or three-digit integer number.</paragraph>
-<embed href="text/scalc/00/00000004.xhp#codes"/>
-
-<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3145634" role="code">CHAR(Number)</paragraph>
-<paragraph id="par_id3155906" role="paragraph"> <emph>Number</emph> is a number between 1 and 255 representing the code value for the character.</paragraph>
-
-<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3149890" role="paragraph"> <item type="input">=CHAR(100)</item> returns the character d.</paragraph>
-<paragraph id="par_id0907200910283297" role="paragraph">="abc" &amp; CHAR(10) &amp; "def" inserts a newline character into the string.</paragraph>
-</section>
+<section id="char"><embed href="text/scalc/01/func_char.xhp#func_char"/></section>
 
-<section id="clean">
-<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"/>
-
-<h2 id="hd_id3149009">CLEAN</h2>
-<paragraph id="par_id3150482" role="paragraph"><ahelp hid="HID_FUNC_SAEUBERN">All non-printing characters are removed from the string.</ahelp></paragraph>
-
-<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>
+<section id="clean"><embed href="text/scalc/01/func_clean.xhp#func_clean"/></section>
 
 <section id="code">
 <bookmark branch="index" id="bm_id3155498">
@@ -723,4 +688,4 @@
 </section>
 </body>
 
-</helpdocument>
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/func_char.xhp b/source/text/scalc/01/func_char.xhp
new file mode 100644
index 0000000000..5b2db08ace
--- /dev/null
+++ b/source/text/scalc/01/func_char.xhp
@@ -0,0 +1,38 @@
+<?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_char" indexer="include" status="PUBLISH">
+      <title id="tit">CHAR Function</title>
+      <filename>/text/scalc/01/func_char.xhp</filename>
+    </topic>
+  </meta>
+  <body>
+    <bookmark branch="index" id="bm_id3149321">
+  <bookmark_value>CHAR function</bookmark_value>
+</bookmark>
+    <bookmark branch="hid/SC_HID_FUNC_ZEICHEN" id="bm_id3159128" localize="false"/>
+    <section id="func_char">
+      <h1 id="hd_id3149321">
+        <variable id="char_h1">
+          <link href="text/scalc/01/func_char.xhp">CHAR</link>
+        </variable>
+      </h1>
+      <paragraph id="par_id3149150" role="paragraph"><ahelp hid="HID_FUNC_ZEICHEN">Converts a number into a character according to the current code table.</ahelp> The number can be a two-digit or three-digit integer number.</paragraph>
+    </section>
+    <embed href="text/scalc/00/00000004.xhp#codes"/>
+    <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
+    <paragraph id="par_id3145634" role="code">CHAR(Number)</paragraph>
+    <paragraph id="par_id3155906" role="paragraph"> <emph>Number</emph> is a number between 1 and 255 representing the code value for the character.</paragraph>
+    <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+    <paragraph id="par_id3149890" role="paragraph"> <item type="input">=CHAR(100)</item> returns the character d.</paragraph>
+    <paragraph id="par_id0907200910283297" role="paragraph">="abc" &amp; CHAR(10) &amp; "def" inserts a newline character into the string.</paragraph>
+  </body>
+</helpdocument>
\ No newline at end of file
diff --git a/source/text/scalc/01/func_clean.xhp b/source/text/scalc/01/func_clean.xhp
new file mode 100644
index 0000000000..9897db361c
--- /dev/null
+++ b/source/text/scalc/01/func_clean.xhp
@@ -0,0 +1,38 @@
+<?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>
+  </body>
+</helpdocument>
\ No newline at end of file