cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lala
Level VIII

How can use the regex substitution <*>?

How to use regex to replace the text of dt[1,"A"] with tabs for each <*>.It get the multi-column result in row 2.

2021-03-07_16-36-24.png

Thanks!

abc<ahref="/cindex/list->897</a>"id="s897"</dd>

 

11 REPLIES 11
lala
Level VIII

Re: How can use the regex substitution <*>?

How to write this regex substitution in JSL?I can't write it this way.Continue to seek expert help!

Thanks Experts!

tx = Regex(tx, "</a></em></span><span>《<a href=\!"/gushi/([a-Z][^/]{0,})/([0-9]{0,}).html\!">", "\!t", GLOBALREPLACE);

20240326154234.png

gle || []).push({});</script><div><span>111.</span><span><a class="name" href="/shiju/843.html">过春风十里,尽荠麦青青。</a></span><span>——</span><span><em><a href="/shiren/jiangkui/" class="author">姜夔</a></em></span><span>《<a href="/gushi/ci/1672.html">扬州慢·淮左名都</a>》</span></div><div><span>112.</span><span><a class="name" href="/shiju/897.html">一树春风千万枝,嫩于金色软于丝。</a></span><span>——</span><span><em><a href="/shiren/baijuyi/" class="author">白居易</a></em></span><span>《<a href="/gushi/shi/2070.html">杨柳枝词</a>》</span></div><div><span>113.</span><span><a class="name" href="/shiju/898.html">天时人事日相催,冬至阳生春又来。</a></span><span>——</span><span><em><a href="/shiren/dufu/" class="author">杜甫</a></em></span><span>《<a href="/gushi/shi/2087.html">小至</a>》</span></div><div><span>114.</span><span><a class="name" href="/shiju/905.html">寻得桃源好避秦,桃红又是一年春。</a></span><span>——</span><span><em><a href="/shiren/xiefangde/" class="author">谢枋得</a></em></span><span>《<a href="/gushi/shi/2223.html">庆全庵桃花</a>》</span></div><div><span>115.</span><span><a class="name" href="/shiju/934.html">春巷夭桃吐绛英,春衣初试薄罗轻。风和烟暖燕巢成。</a></span><span>——</span><span><em><a href="/shiren/zhushuzhen/" class="author">朱淑真</a></em></span><span>《<a href="/gushi/ci/2473.html">浣溪沙·清明</a>》</span></div><div><span>116.</span><span><a class="name" href="/shiju/936.html">好是风和日暖,输与莺莺燕燕。满院落花帘不卷,断肠芳草远。</a></span><span>——</span><span><em><a href="/shiren/zhushuzhen/" class="author">朱淑真</a></em></span><span>《<a href="/gushi/ci/2475.html">谒金门·春半</a>》</span></div><<div><span>133.</span><span><a class="name" href="/shiju/1125.html">春共山中采,香宜竹里煎。</a></span></div><div><span>134.</span><span><a class="name" href="/shiju/1148.html">青画溪头翠水家,水边短竹夹桃花。</a></span><span>——</span><span><em><a href="/shiren/yangweizhen/" class="author">杨维桢</a></em></span><span>《<a href="/gushi/shi/2734.html">漫兴七首</a>》</span></div><div><span>135.</span><span><a class="name" href="/shiju/1149.html">杨花白白绵初迸,梅子青青核未生。</a></span><span>——</span><span><em><a href="/shiren/yangweizhen/" class="author">杨维桢</a></em></span><span>《<a href="/gushi/shi/2734.html">漫兴七首</a>》</span></div>

2024-03-26_15-29-25.png

 

Craige_Hales
Super User

Re: How can use the regex substitution <*>?

use a-zA-Z is probably what you want.

lowercase a comes AFTER uppercase Z

https://en.wikipedia.org/wiki/ASCII#/media/File:USASCII_code_chart.png

 

Craige