topic Re: String Operations after Reading from Excel in Discussions

String Operations after Reading from Excel

CircularPuppy35 — Tue, 15 Aug 2023 16:39:51 GMT

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

Re: String Operations after Reading from Excel

txnelson — Tue, 15 Aug 2023 18:39:28 GMT

Use the Substitute() function to ca hange characters

Re: String Operations after Reading from Excel

CircularPuppy35 — Tue, 15 Aug 2023 19:14:02 GMT

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!

Re: String Operations after Reading from Excel

jthi — Tue, 15 Aug 2023 19:38:46 GMT

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