cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
UersK
Level III

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

],[

Thanks!

 

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

Accepted Solutions
jthi
Super User

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

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);

https://www.jmp.com/support/help/en/17.0/index.shtml#page/jmp/jsl-syntax-rules.shtml

https://www.jmp.com/support/help/en/17.0/index.shtml#page/jmp/escaped-characters-in-regular-expressi...

 

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

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

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);

https://www.jmp.com/support/help/en/17.0/index.shtml#page/jmp/jsl-syntax-rules.shtml

https://www.jmp.com/support/help/en/17.0/index.shtml#page/jmp/escaped-characters-in-regular-expressi...

 

-Jarmo