cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lwx228
Level VIII

Using JSL to download Web JSON data, can be directly written into the matrix?

A table in all digital format can be downloaded using the following JSL.

u = "http……";
txt = Load Text File( u );
loc1 = "[{";
offset = Contains( txt, loc1 );
If( offset,
	txt = Substr( txt, offset, Length( txt ) )
);
loc2 = "}]";
offset = Contains( txt, loc2, -1 );
If( offset,
	txt = Substr( txt, 1, offset + 1 )
);
d1 = JSON To Data Table( txt );//without going through a "d1" file.


How to write the data directly into the matrix without going through a "d1" file.

 

Thanks Experts!

2 REPLIES 2
Craige_Hales
Super User

Re: Using JSL to download Web JSON data, can be directly written into the matrix?

What problem are you trying to solve? The download time will be 100 times as long as the conversion from table to matrix.

Craige
lwx228
Level VIII

Re: Using JSL to download Web JSON data, can be directly written into the matrix?

OK.

table to matrix.

Thank Craige!

Recommended Articles