Save data table with tab delimiter through script

yossi_tokash — Mon, 06 Aug 2018 05:29:57 GMT

Hi Guy's,

Is is possible to save a jmp data table to a text file with tab delimiter using a script ?

Thanks in advance,

Yossi

Re: Save data table with tab delimiter through script

gzmorgan0 — Mon, 06 Aug 2018 07:04:06 GMT

Yes. Here is an example.

Names Default to Here(1);

dt = Open("$Sample_Data/Big Class.jmp");

//modified excerpt from JSL Companion script "2_Extra_SaveText.jsl"
// Save as text with tab delimiters
// Get user Export Preferences
xptPref = Get Preferences( Export Settings );

// Set desired Export Preferences
Preferences(
	ExportSettings(
		End Of Line( CRLF ),
		End Of Field( Tab ),  //optionally try: Comma|Space|Other("|")|Other("^") etc
		Export Table Headers( 1 )
	)
);

// Save as .txt
dt << Save( "c:/temp/bigclass_tabs.txt" );

// Reset user Export Preferences
Eval( xptPref ); 

// xptPref;  // works as well.

topic Save data table with tab delimiter through script in Discussions

Save data table with tab delimiter through script

Re: Save data table with tab delimiter through script