Save data table with tab delimiter through script

[#1]

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

[#2 · Accepted solution]

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.