String Operations after Reading from Excel

[#1]

Hello, 

I am reading a cell from Excel which is read by JMP as - "['299','523']". I need the string to be manipulated to be {"299","523"}. I am not able to do this. 

Any help would be appreciated. There probably is an easy solution but I cannot figure it out. 

Thanks,

Neel

[#2]

Use the Substitute() function to ca hange characters

[#3]

Hi Jim, 

I tried that already, but I cannot replace " (double quotes) in the string with an empty space. Any suggestions?

This: temp = Substitute(string,""\", " "); doesn't work and I get errors.

Thanks!

[#4]

Substitute should work fine here

Names Default To Here(1);

str = "['299','523']";

str2 = Substitute(str, "'", "\!"", "[", "{", "]", "}");

Write(str2);

You can find escape sequences for quoted strings here Scripting Guide > JSL Building Blocks > JSL Syntax Rules