How can replace the following with a newline with a regular substitution in JMP software's JSL

UersK — Fri, 09 Jun 2023 16:09:15 GMT

],[

Thanks!

t1=Regex(txt,"],[","\!n",globalreplace);//??

Re: How can replace the following with a newline with a regular substitution in JMP software's JSL

jthi — Wed, 03 May 2023 13:27:21 GMT

You need to escape [ and ] in regex (you could also use Substitute/Substitute Into)

Names Default To Here(1);

txt = "a],[b";
t1 = Regex(txt, "\!],\!\[", "\!n", GLOBALREPLACE);
t2 = Substitute(txt, "],[", "\!N");
show(t1, t2);