cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lala
Level IX

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 IX

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

Recommended Articles