Choose Language Hide Translation Bar
yossi_tokash
Level I

Save data table with tab delimiter through script

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: Save data table with tab delimiter through script

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.

View solution in original post

1 REPLY 1
Highlighted
gzmorgan0
Super User

Re: Save data table with tab delimiter through script

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.

View solution in original post

Article Labels

    There are no labels assigned to this post.