正则问题

Gentleman · 发表于 2024-10-10 03:19:11

文本：

<tr>
<td>2024-10-09  00:00-01:00</td>
<td>
全部渠道
</td>
<td data-sort-value="9">9</td>
<td data-sort-value="0">0</td>
<td data-sort-value="42">42</td>
<td data-sort-value="3">3</td>
<td data-sort-value="20">20</td>
<td data-sort-value="2930">?2930</td>
<td data-sort-value="38395">?38395</td>
<td data-sort-value="33.333333333333">33.33%</td>
<td data-sort-value="4">4</td>
<td data-sort-value="47.619047619048">47.62%</td>
<td data-sort-value="1919.75">?1919.75</td>
<td data-sort-value="914.16666666667">?914.17</td>
</tr>
<tr>
<td>2024-10-09  00:00-02:00</td>
<td>
全部渠道
</td>
<td data-sort-value="14">14</td>
<td data-sort-value="0">0</td>
<td data-sort-value="54">54</td>
<td data-sort-value="9">9</td>
<td data-sort-value="29">29</td>
<td data-sort-value="20054">?20054</td>
<td data-sort-value="73868">?73868</td>
<td data-sort-value="64.285714285714">64.29%</td>
<td data-sort-value="10">10</td>
<td data-sort-value="53.703703703704">53.70%</td>
<td data-sort-value="2547.1724137931">?2547.17</td>
<td data-sort-value="1367.9259259259">?1367.93</td>
</tr>
<tr>
<td>2024-10-09  00:00-03:00</td>
<td>
全部渠道
</td>
<td data-sort-value="19">19</td>
<td data-sort-value="0">0</td>
<td data-sort-value="68">68</td>
<td data-sort-value="12">12</td>
<td data-sort-value="36">36</td>
<td data-sort-value="31050">?31050</td>
<td data-sort-value="86068">?86068</td>
<td data-sort-value="63.157894736842">63.16%</td>
<td data-sort-value="14">14</td>
<td data-sort-value="52.941176470588">52.94%</td>
<td data-sort-value="2390.7777777778">?2390.78</td>
<td data-sort-value="1265.7058823529">?1265.71</td>
</tr>
<tr>
<td>2024-10-09  00:00-04:00</td>
<td>
全部渠道
</td>
<td data-sort-value="29">29</td>
<td data-sort-value="0">0</td>
<td data-sort-value="82">82</td>
<td data-sort-value="18">18</td>
<td data-sort-value="44">44</td>
<td data-sort-value="39131">?39131</td>
<td data-sort-value="97811">?97811</td>
<td data-sort-value="62.068965517241">62.07%</td>
<td data-sort-value="20">20</td>
<td data-sort-value="53.658536585366">53.66%</td>
<td data-sort-value="2222.9772727273">?2222.98</td>
<td data-sort-value="1192.8170731707">?1192.82</td>
</tr>
<tr>
<td>2024-10-09  00:00-05:00</td>
<td>
全部渠道
</td>
<td data-sort-value="32">32</td>
<td data-sort-value="0">0</td>
<td data-sort-value="91">91</td>
<td data-sort-value="18">18</td>
<td data-sort-value="45">45</td>
<td data-sort-value="39131">?39131</td>
<td data-sort-value="100517">?100517</td>
<td data-sort-value="56.25">56.25%</td>
<td data-sort-value="20">20</td>
<td data-sort-value="49.450549450549">49.45%</td>
<td data-sort-value="2233.7111111111">?2233.71</td>
<td data-sort-value="1104.5824175824">?1104.58</td>
</tr>
<tr>
<td>2024-10-09  00:00-06:00</td>
<td>
全部渠道
</td>
<td data-sort-value="33">33</td>
<td data-sort-value="0">0</td>
<td data-sort-value="98">98</td>
<td data-sort-value="19">19</td>
<td data-sort-value="47">47</td>
<td data-sort-value="40197">?40197</td>
<td data-sort-value="122825">?122825</td>
<td data-sort-value="57.575757575758">57.58%</td>
<td data-sort-value="22">22</td>
<td data-sort-value="47.959183673469">47.96%</td>
<td data-sort-value="2613.2978723404">?2613.30</td>
<td data-sort-value="1253.3163265306">?1253.32</td>
</tr>
<tr>
<td>2024-10-09  00:00-07:00</td>
<td>
全部渠道
</td>
<td data-sort-value="38">38</td>
<td data-sort-value="0">0</td>
<td data-sort-value="119">119</td>
<td data-sort-value="19">19</td>
<td data-sort-value="49">49</td>
<td data-sort-value="40197">?40197</td>
<td data-sort-value="324995">?324995</td>
<td data-sort-value="50">50.00%</td>
<td data-sort-value="22">22</td>
<td data-sort-value="41.176470588235">41.18%</td>
<td data-sort-value="6632.5510204082">?6632.55</td>
<td data-sort-value="2731.0504201681">?2731.05</td>
</tr>
<tr>
<td>2024-10-09  00:00-08:00</td>
<td>
全部渠道
</td>
<td data-sort-value="42">42</td>
<td data-sort-value="0">0</td>
<td data-sort-value="144">144</td>
<td data-sort-value="20">20</td>
<td data-sort-value="53">53</td>
<td data-sort-value="41197">?41197</td>
<td data-sort-value="353771">?353771</td>
<td data-sort-value="47.619047619048">47.62%</td>
<td data-sort-value="23">23</td>
<td data-sort-value="36.805555555556">36.81%</td>
<td data-sort-value="6674.9245283019">?6674.92</td>
<td data-sort-value="2456.7430555556">?2456.74</td>
</tr>
<tr>
<td>2024-10-09  00:00-09:00</td>
<td>
全部渠道
</td>
<td data-sort-value="49">49</td>
<td data-sort-value="0">0</td>
<td data-sort-value="174">174</td>
<td data-sort-value="21">21</td>
<td data-sort-value="59">59</td>
<td data-sort-value="43413">?43413</td>
<td data-sort-value="360607">?360607</td>
<td data-sort-value="42.857142857143">42.86%</td>
<td data-sort-value="25">25</td>
<td data-sort-value="33.908045977011">33.91%</td>
<td data-sort-value="6111.9830508475">?6111.98</td>
<td data-sort-value="2072.4540229885">?2072.45</td>
</tr>
<tr>
<td>2024-10-09  00:00-10:00</td>
<td>
全部渠道
</td>
<td data-sort-value="58">58</td>
<td data-sort-value="0">0</td>
<td data-sort-value="198">198</td>
<td data-sort-value="24">24</td>
<td data-sort-value="68">68</td>
<td data-sort-value="44967">?44967</td>
<td data-sort-value="400968">?400968</td>
<td data-sort-value="41.379310344828">41.38%</td>
<td data-sort-value="31">31</td>
<td data-sort-value="34.343434343434">34.34%</td>
<td data-sort-value="5896.5882352941">?5896.59</td>
<td data-sort-value="2025.0909090909">?2025.09</td>
</tr>
<tr>
<td>2024-10-09  00:00-11:00</td>
<td>
全部渠道
</td>
<td data-sort-value="66">66</td>
<td data-sort-value="0">0</td>
<td data-sort-value="218">218</td>
<td data-sort-value="26">26</td>
<td data-sort-value="78">78</td>
<td data-sort-value="46403">?46403</td>
<td data-sort-value="421763">?421763</td>
<td data-sort-value="39.393939393939">39.39%</td>
<td data-sort-value="35">35</td>
<td data-sort-value="35.779816513761">35.78%</td>
<td data-sort-value="5407.2179487179">?5407.22</td>
<td data-sort-value="1934.6926605505">?1934.69</td>
</tr>
<tr>
<td>2024-10-09  00:00-12:00</td>
<td>
全部渠道
</td>
<td data-sort-value="75">75</td>
<td data-sort-value="0">0</td>
<td data-sort-value="248">248</td>
<td data-sort-value="28">28</td>
<td data-sort-value="83">83</td>
<td data-sort-value="47735">?47735</td>
<td data-sort-value="429517">?429517</td>
<td data-sort-value="37.333333333333">37.33%</td>
<td data-sort-value="37">37</td>
<td data-sort-value="33.467741935484">33.47%</td>
<td data-sort-value="5174.9036144578">?5174.90</td>
<td data-sort-value="1731.9233870968">?1731.92</td>
</tr>
<tr>
<td>2024-10-09  00:00-13:00</td>
<td>
全部渠道
</td>
<td data-sort-value="86">86</td>
<td data-sort-value="0">0</td>
<td data-sort-value="276">276</td>
<td data-sort-value="33">33</td>
<td data-sort-value="89">89</td>
<td data-sort-value="55194">?55194</td>
<td data-sort-value="439251">?439251</td>
<td data-sort-value="38.372093023256">38.37%</td>
<td data-sort-value="42">42</td>
<td data-sort-value="32.246376811594">32.25%</td>
<td data-sort-value="4935.404494382">?4935.40</td>
<td data-sort-value="1591.4891304348">?1591.49</td>
</tr>
<tr>
<td>2024-10-09  00:00-14:00</td>
<td>
全部渠道
</td>
<td data-sort-value="99">99</td>
<td data-sort-value="0">0</td>
<td data-sort-value="301">301</td>
<td data-sort-value="37">37</td>
<td data-sort-value="99">99</td>
<td data-sort-value="63769">?63769</td>
<td data-sort-value="453860">?453860</td>
<td data-sort-value="37.373737373737">37.37%</td>
<td data-sort-value="47">47</td>
<td data-sort-value="32.890365448505">32.89%</td>
<td data-sort-value="4584.4444444444">?4584.44</td>
<td data-sort-value="1507.8405315615">?1507.84</td>
</tr>
<tr>
<td>2024-10-09  00:00-15:00</td>
<td>
全部渠道
</td>
<td data-sort-value="117">117</td>
<td data-sort-value="0">0</td>
<td data-sort-value="325">325</td>
<td data-sort-value="44">44</td>
<td data-sort-value="108">108</td>
<td data-sort-value="72658">?72658</td>
<td data-sort-value="471291">?471291</td>
<td data-sort-value="37.606837606838">37.61%</td>
<td data-sort-value="55">55</td>
<td data-sort-value="33.230769230769">33.23%</td>
<td data-sort-value="4363.8055555556">?4363.81</td>
<td data-sort-value="1450.1261538462">?1450.13</td>
</tr>
<tr>
<td>2024-10-09  00:00-16:00</td>
<td>
全部渠道
</td>
<td data-sort-value="135">135</td>
<td data-sort-value="0">0</td>
<td data-sort-value="350">350</td>
<td data-sort-value="53">53</td>
<td data-sort-value="121">121</td>
<td data-sort-value="81893">?81893</td>
<td data-sort-value="503396">?503396</td>
<td data-sort-value="39.259259259259">39.26%</td>
<td data-sort-value="66">66</td>
<td data-sort-value="34.571428571429">34.57%</td>
<td data-sort-value="4160.2975206612">?4160.30</td>
<td data-sort-value="1438.2742857143">?1438.27</td>
</tr>
<tr>
<td>2024-10-09  00:00-17:00</td>
<td>
全部渠道
</td>
<td data-sort-value="148">148</td>
<td data-sort-value="0">0</td>
<td data-sort-value="372">372</td>
<td data-sort-value="60">60</td>
<td data-sort-value="128">128</td>
<td data-sort-value="94436">?94436</td>
<td data-sort-value="519463">?519463</td>
<td data-sort-value="40.540540540541">40.54%</td>
<td data-sort-value="73">73</td>
<td data-sort-value="34.408602150538">34.41%</td>
<td data-sort-value="4058.3046875">?4058.30</td>
<td data-sort-value="1396.4059139785">?1396.41</td>
</tr>
<tr>
<td>2024-10-09  00:00-18:00</td>
<td>
全部渠道
</td>
<td data-sort-value="157">157</td>
<td data-sort-value="0">0</td>
<td data-sort-value="389">389</td>
<td data-sort-value="62">62</td>
<td data-sort-value="132">132</td>
<td data-sort-value="97540">?97540</td>
<td data-sort-value="534251">?534251</td>
<td data-sort-value="39.490445859873">39.49%</td>
<td data-sort-value="76">76</td>
<td data-sort-value="33.933161953728">33.93%</td>
<td data-sort-value="4047.3560606061">?4047.36</td>
<td data-sort-value="1373.3958868895">?1373.40</td>
</tr>
<tr>
<td>2024-10-09  00:00-19:00</td>
<td>
全部渠道
</td>
<td data-sort-value="166">166</td>
<td data-sort-value="0">0</td>
<td data-sort-value="414">414</td>
<td data-sort-value="65">65</td>
<td data-sort-value="137">137</td>
<td data-sort-value="101208">?101208</td>
<td data-sort-value="539807">?539807</td>
<td data-sort-value="39.156626506024">39.16%</td>
<td data-sort-value="80">80</td>
<td data-sort-value="33.091787439614">33.09%</td>
<td data-sort-value="3940.197080292">?3940.20</td>
<td data-sort-value="1303.8816425121">?1303.88</td>
</tr>

分别为：时间、数据1、数据2、数据3、数据4、数据5、数据6、数据7、数据8、数据9、数据10、数据11、数据12、数据13
插入到对应的超级列表框标题，并导出为表格。

咪兔 · 发表于 2024-10-10 03:19:12

(\d{4}-\d{2}-\d{2})[^\0]+?(\d{2}:\d{2}-\d{2}:\d{2})[^\0]*?<td*?>\s*(\S+)\s*<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>

haoren1212 · 发表于 2024-10-10 03:43:06

分割数组<tr></tr>，计次分割数组，批量取中间文本（取引号里的，保存为数组），计次数组赋值列表框

BruceJoysky1987 · 发表于 2024-10-10 04:26:15

局_正则.创建 (“ ” ＋ #换行符＋ “ (.*) (.*)” ＋ #换行符＋ “ ” ＋ #换行符＋ “ 全部渠道” ＋ #换行符＋ “ ” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ 0” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ ?(.*)” ＋ #换行符＋ “ ?(.*)” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ (.*)” ＋ #换行符＋ “ ?(.*)” ＋ #换行符＋ “ ?(.*)” ＋ #换行符＋ “ ”, 源文本, 假, 假, 真,真)

Gentleman · 发表于 2024-10-10 09:46:44

咪兔发表于 2024-10-10 05:31
(\d{4}-\d{2}-\d{2})[^\0]+?(\d{2}:\d{2}-\d{2}:\d{2})[^\0]*?\s*(\S+)\s*\s*(.*?)\s*(.*?)\s*(.*?)\s*(.*? ...

   <tr>
                              <td>2024-10-09  00:00-19:00</td>
                              <td>
                                                                                                                     全部渠道
                              </td>
                              <td data-sort-value="166">166</td>
                              <td data-sort-value="0">0</td>
                              <td data-sort-value="414">414</td>
                              <td data-sort-value="65">65</td>
                              <td data-sort-value="137">137</td>
                              <td data-sort-value="101208">?101208</td>
                              <td data-sort-value="539807">?539807</td>
                                                            <td data-sort-value="39.156626506024">39.16%</td>
                              <td data-sort-value="80">80</td>
                                                            <td data-sort-value="33.091787439614">33.09%</td>
                                                            <td data-sort-value="3940.197080292">?3940.20</td>
                                                            <td data-sort-value="1303.8816425121">?1303.88</td>
                     </tr>

只取标红的要怎么办呢，文本1和文本3不需要

初夏喔 · 发表于 2024-10-10 11:50:54

Gentleman 发表于 2024-10-10 09:46
2024-10-09 00:00-19:00

...

不管你要不要这些都是会匹配的，不会影响速度。如果你真不想要你把第一对第三对括号去掉就行了

[JavaScript] 纯文本查看 复制代码

\d{4}-\d{2}-\d{2}[^\0]+?(\d{2}:\d{2}-\d{2}:\d{2})[^\0]*?<td*?>\s*\S+\s*<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>\s*<td.*?>(.*?)<\/td>

		自动登录	找回密码
密码			注册

[已解决] 正则问题

最佳答案

评分