Google Git
Sign in
apache/iotdb-website/refs/heads/asf-staging/./assets/String-Processing.html-A7UXvC9q.js
blob: b18a17f95baf71d5531a267adbe82e9b295395f5 [file]
import{_ as e,c as n,b as a,o as l}from"./app-C1IcKGP3.js";const i={};function p(t,s){return l(),n("div",null,[...s[0]||(s[0]=[a(`<h1 id="string-processing" tabindex="-1"><a class="header-anchor" href="#string-processing"><span>String Processing</span></a></h1><h2 id="regexmatch" tabindex="-1"><a class="header-anchor" href="#regexmatch"><span>RegexMatch</span></a></h2><h3 id="usage" tabindex="-1"><a class="header-anchor" href="#usage"><span>Usage</span></a></h3><p>The function is used to fetch matched contents from text with given regular expression.</p><p><strong>Name:</strong> REGEXMATCH</p><p><strong>Input Series:</strong> Only support a single input series. The data type is TEXT.</p><p><strong>Parameter:</strong></p><ul><li><code>regex</code>: The regular expression to match in the text. All grammars supported by Java are acceptable,<br> for example, <code>\\d+\\.\\d+\\.\\d+\\.\\d+</code> is expected to match any IPv4 addresses.</li><li><code>group</code>: The wanted group index in the matched result.<br> Reference to java.util.regex, group 0 is the whole pattern and<br> the next ones are numbered with the appearance order of left parentheses.<br> For example, the groups in <code>A(B(CD))</code> are: 0-<code>A(B(CD))</code>, 1-<code>B(CD)</code>, 2-<code>CD</code>.</li></ul><p><strong>Output Series:</strong> Output a single series. The type is TEXT.</p><p><strong>Note:</strong> Those points with null values or not matched with the given pattern will not return any results.</p><h3 id="examples" tabindex="-1"><a class="header-anchor" href="#examples"><span>Examples</span></a></h3><p>Input series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-------------------------------+</span></span>
<span class="line"><span>| Time| root.test.d1.s1|</span></span>
<span class="line"><span>+-----------------------------+-------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| [192.168.0.1] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| [192.168.0.24] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| [192.168.0.2] [FAIL]|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| [192.168.0.5] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| [192.168.0.124] [SUCCESS]|</span></span>
<span class="line"><span>+-----------------------------+-------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> regexmatch(s1, </span><span style="color:#98C379;">&quot;regex&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;\\d+\\.\\d+\\.\\d+\\.\\d+&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;group&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;0&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+----------------------------------------------------------------------+</span></span>
<span class="line"><span>| Time|regexmatch(root.test.d1.s1, &quot;regex&quot;=&quot;\\d+\\.\\d+\\.\\d+\\.\\d+&quot;, &quot;group&quot;=&quot;0&quot;)|</span></span>
<span class="line"><span>+-----------------------------+----------------------------------------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| 192.168.0.1|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| 192.168.0.24|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| 192.168.0.2|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| 192.168.0.5|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| 192.168.0.124|</span></span>
<span class="line"><span>+-----------------------------+----------------------------------------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="regexreplace" tabindex="-1"><a class="header-anchor" href="#regexreplace"><span>RegexReplace</span></a></h2><h3 id="usage-1" tabindex="-1"><a class="header-anchor" href="#usage-1"><span>Usage</span></a></h3><p>The function is used to replace the specific regular expression matches with given string.</p><p><strong>Name:</strong> REGEXREPLACE</p><p><strong>Input Series:</strong> Only support a single input series. The data type is TEXT.</p><p><strong>Parameter:</strong></p><ul><li><code>regex</code>: The target regular expression to be replaced. All grammars supported by Java are acceptable.</li><li><code>replace</code>: The string to be put on and back reference notes in Java is also supported,<br> for example, &#39;$1&#39; refers to group 1 in the <code>regex</code> which will be filled with corresponding matched results.</li><li><code>limit</code>: The number of matches to be replaced which should be an integer no less than -1,<br> default to -1 which means all matches will be replaced.</li><li><code>offset</code>: The number of matches to be skipped, which means the first <code>offset</code> matches will not be replaced, default to 0.</li><li><code>reverse</code>: Whether to count all the matches reversely, default to &#39;false&#39;.</li></ul><p><strong>Output Series:</strong> Output a single series. The type is TEXT.</p><h3 id="examples-1" tabindex="-1"><a class="header-anchor" href="#examples-1"><span>Examples</span></a></h3><p>Input series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-------------------------------+</span></span>
<span class="line"><span>| Time| root.test.d1.s1|</span></span>
<span class="line"><span>+-----------------------------+-------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| [192.168.0.1] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| [192.168.0.24] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| [192.168.0.2] [FAIL]|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| [192.168.0.5] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| [192.168.0.124] [SUCCESS]|</span></span>
<span class="line"><span>+-----------------------------+-------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> regexreplace(s1, </span><span style="color:#98C379;">&quot;regex&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;192\\.168\\.0\\.(\\d+)&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;replace&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;cluster-$1&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;limit&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;1&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-----------------------------------------------------------+</span></span>
<span class="line"><span>| Time|regexreplace(root.test.d1.s1, &quot;regex&quot;=&quot;192\\.168\\.0\\.(\\d+)&quot;,|</span></span>
<span class="line"><span>| | &quot;replace&quot;=&quot;cluster-$1&quot;, &quot;limit&quot;=&quot;1&quot;)|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| [cluster-1] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| [cluster-24] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| [cluster-2] [FAIL]|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| [cluster-5] [SUCCESS]|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| [cluster-124] [SUCCESS]|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="regexsplit" tabindex="-1"><a class="header-anchor" href="#regexsplit"><span>RegexSplit</span></a></h2><h3 id="usage-2" tabindex="-1"><a class="header-anchor" href="#usage-2"><span>Usage</span></a></h3><p>The function is used to split text with given regular expression and return specific element.</p><p><strong>Name:</strong> REGEXSPLIT</p><p><strong>Input Series:</strong> Only support a single input series. The data type is TEXT.</p><p><strong>Parameter:</strong></p><ul><li><code>regex</code>: The regular expression used to split the text.<br> All grammars supported by Java are acceptable, for example, <code>[&#39;&quot;]</code> is expected to match <code>&#39;</code> and <code>&quot;</code>.</li><li><code>index</code>: The wanted index of elements in the split result.<br> It should be an integer no less than -1, default to -1 which means the length of the result array is returned<br> and any non-negative integer is used to fetch the text of the specific index starting from 0.</li></ul><p><strong>Output Series:</strong> Output a single series. The type is INT32 when <code>index</code> is -1 and TEXT when it&#39;s an valid index.</p><p><strong>Note:</strong> When <code>index</code> is out of the range of the result array, for example <code>0,1,2</code> split with <code>,</code> and <code>index</code> is set to 3,<br> no result are returned for that record.</p><h3 id="examples-2" tabindex="-1"><a class="header-anchor" href="#examples-2"><span>Examples</span></a></h3><p>Input series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+---------------+</span></span>
<span class="line"><span>| Time|root.test.d1.s1|</span></span>
<span class="line"><span>+-----------------------------+---------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| A,B,A+,B-|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| A,A+,A,B+|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| B+,B,B|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| A+,A,A+,A|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| A,B-,B,B|</span></span>
<span class="line"><span>+-----------------------------+---------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> regexsplit(s1, </span><span style="color:#98C379;">&quot;regex&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;,&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;index&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;-1&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+------------------------------------------------------+</span></span>
<span class="line"><span>| Time|regexsplit(root.test.d1.s1, &quot;regex&quot;=&quot;,&quot;, &quot;index&quot;=&quot;-1&quot;)|</span></span>
<span class="line"><span>+-----------------------------+------------------------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| 4|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| 4|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| 3|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| 4|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| 4|</span></span>
<span class="line"><span>+-----------------------------+------------------------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>Another SQL for query:</p><p>SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> regexsplit(s1, </span><span style="color:#98C379;">&quot;regex&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;,&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;index&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;3&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span>
<span class="line"><span>| Time|regexsplit(root.test.d1.s1, &quot;regex&quot;=&quot;,&quot;, &quot;index&quot;=&quot;3&quot;)|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| B-|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| B+|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| A|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| B|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="strreplace" tabindex="-1"><a class="header-anchor" href="#strreplace"><span>StrReplace</span></a></h2><h3 id="usage-3" tabindex="-1"><a class="header-anchor" href="#usage-3"><span>Usage</span></a></h3><p>The function is used to replace the specific substring with given string.</p><p><strong>Name:</strong> STRREPLACE</p><p><strong>Input Series:</strong> Only support a single input series. The data type is TEXT.</p><p><strong>Parameter:</strong></p><ul><li><code>target</code>: The target substring to be replaced.</li><li><code>replace</code>: The string to be put on.</li><li><code>limit</code>: The number of matches to be replaced which should be an integer no less than -1,<br> default to -1 which means all matches will be replaced.</li><li><code>offset</code>: The number of matches to be skipped, which means the first <code>offset</code> matches will not be replaced, default to 0.</li><li><code>reverse</code>: Whether to count all the matches reversely, default to &#39;false&#39;.</li></ul><p><strong>Output Series:</strong> Output a single series. The type is TEXT.</p><h3 id="examples-3" tabindex="-1"><a class="header-anchor" href="#examples-3"><span>Examples</span></a></h3><p>Input series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+---------------+</span></span>
<span class="line"><span>| Time|root.test.d1.s1|</span></span>
<span class="line"><span>+-----------------------------+---------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| A,B,A+,B-|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| A,A+,A,B+|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| B+,B,B|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| A+,A,A+,A|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| A,B-,B,B|</span></span>
<span class="line"><span>+-----------------------------+---------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> strreplace(s1, </span><span style="color:#98C379;">&quot;target&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;,&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;replace&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;/&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;limit&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;2&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-----------------------------------------+</span></span>
<span class="line"><span>| Time|strreplace(root.test.d1.s1, &quot;target&quot;=&quot;,&quot;,|</span></span>
<span class="line"><span>| | &quot;replace&quot;=&quot;/&quot;, &quot;limit&quot;=&quot;2&quot;)|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| A/B/A+,B-|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| A/A+/A,B+|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| B+/B/B|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| A+/A/A+,A|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| A/B-/B,B|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>Another SQL for query:</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> strreplace(s1, </span><span style="color:#98C379;">&quot;target&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;,&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;replace&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;/&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;limit&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;1&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;offset&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;1&quot;</span><span style="color:#ABB2BF;">, </span><span style="color:#98C379;">&quot;reverse&quot;</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&quot;true&quot;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">test</span><span style="color:#ABB2BF;">.d1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p>Output series:</p><div class="language- line-numbers-mode" data-highlighter="shiki" data-ext="" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-"><span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span>
<span class="line"><span>| Time|strreplace(root.test.d1.s1, &quot;target&quot;=&quot;,&quot;, &quot;replace&quot;= | </span></span>
<span class="line"><span>| | &quot;|&quot;, &quot;limit&quot;=&quot;1&quot;, &quot;offset&quot;=&quot;1&quot;, &quot;reverse&quot;=&quot;true&quot;)|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span>
<span class="line"><span>|2021-01-01T00:00:01.000+08:00| A,B/A+,B-|</span></span>
<span class="line"><span>|2021-01-01T00:00:02.000+08:00| A,A+/A,B+|</span></span>
<span class="line"><span>|2021-01-01T00:00:03.000+08:00| B+/B,B|</span></span>
<span class="line"><span>|2021-01-01T00:00:04.000+08:00| A+,A/A+,A|</span></span>
<span class="line"><span>|2021-01-01T00:00:05.000+08:00| A,B-/B,B|</span></span>
<span class="line"><span>+-----------------------------+-----------------------------------------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div>`,72)])])}const o=e(i,[["render",p]]),c=JSON.parse('{"path":"/UserGuide/V0.13.x/UDF-Library/String-Processing.html","title":"String Processing","lang":"en-US","frontmatter":{"description":"String Processing RegexMatch Usage The function is used to fetch matched contents from text with given regular expression. Name: REGEXMATCH Input Series: Only support a single i...","head":[["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"String Processing\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2026-01-12T10:25:39.000Z\\",\\"author\\":[]}"],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/V0.13.x/UDF-Library/String-Processing.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"String Processing"}],["meta",{"property":"og:description","content":"String Processing RegexMatch Usage The function is used to fetch matched contents from text with given regular expression. Name: REGEXMATCH Input Series: Only support a single i..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2026-01-12T10:25:39.000Z"}],["meta",{"property":"article:modified_time","content":"2026-01-12T10:25:39.000Z"}],["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/V0.13.x/UDF-Library/String-Processing.html"}]]},"git":{"createdTime":1768213539000,"updatedTime":1768213539000,"contributors":[{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":1,"url":"https://github.com/CritasWang"}]},"readingTime":{"minutes":4.45,"words":1334},"filePathRelative":"UserGuide/V0.13.x/UDF-Library/String-Processing.md","autoDesc":true}');export{o as comp,c as data};