topic Re: How can you do this faster with JSL? in Discussions

How can you do this faster with JSL?

lala — Mon, 25 Mar 2024 12:23:35 GMT

Require these characters to be replaced with the result in the diagram

<a href="/shiju/chuntian/">A11</a></li><li><a href="/shiju/chongyangjie/">C22</a></li><li><a href="/shiju/laoshi/">D3</a></li><li><a href="/shiju/juhua/">B0</a></li><li><a href="/shiju/libie/">B1</a>

Explanation: This kind of data is very large.

I replaced slower with the following code

tx=Substitute(tx,"</a></li><li><a href=\!"/shiju/","\!N","/\!">","\!t");Set Clipboard( tx );

Thanks!

Re: How can you do this faster with JSL?

jthi — Mon, 25 Mar 2024 14:34:29 GMT

What you want to do faster and what do you consider fast? The substitute part takes less than 10 microseconds

Names Default To Here(1);

tx = "\[<a href="/shiju/chuntian/">A11</a></li><li><a href="/shiju/chongyangjie/">C22</a></li><li><a href="/shiju/laoshi/">D3</a></li><li><a href="/shiju/juhua/">B0</a></li><li><a href="/shiju/libie/">B1</a>]\";
s = HP Time();
Substitute(tx, "</a></li><li><a href=\!"/shiju/", "\!N", "/\!">", "\!t");
e = HP Time();

Show(e-s);

Re: How can you do this faster with JSL?

lala — Mon, 25 Mar 2024 14:46:51 GMT

Thanks Experts!

What if the number of rows after replacement reaches 100 million?

Is it faster to replace with regular?

I find that the substitutions written this way are not as fast as the regular substitutions of the text editing software EmEditor.

Re: How can you do this faster with JSL?

jthi — Mon, 25 Mar 2024 14:54:51 GMT

JMP isn't specialized text editor software so maybe the functions haven't been optimized for that use (Substitute does a lot more than just replace text). Maybe you could call EmEditor through Run Program if it is fast enough for you (I still have no idea what is considered fast in this case or what is really the case).