Enter the file name and save

Jackie_ — Fri, 09 Jun 2023 17:02:22 GMT

Hi,

I am trying to create a jsl script where the user can type the file name and save as csv.

Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions?

dt = Current Data Table();

current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) );

Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) );

exC = ".cvs";


Nw = new window(""
				,<< modal(),
								   Text box ("Enter File name"),
					               input = Text edit box("", << Set width(100));,
					               Spacer Box( Size( 20, 10 ) ),
				                   Buttonbox("Export", path = pickDirectory("Select the folder to save .CSV file:");
					               aa = input << get text();
					               exE = Concat( aa, exC );
				)
	
);
save( path || "\" || exE );  /// 

Eval( Parse( "pref(" || current_pref || ")" ) );

Re: Enter the file name and save

txnelson — Fri, 24 Jun 2022 03:45:19 GMT

exC is not recognized within the Modal window, so the simple fix is below

dt = Current Data Table();

current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) );

Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) );

exC = ".cvs";


Nw = New Window( "",
	<<modal(),
	Text Box( "Enter File name" ),
	input = Text Edit Box( "", <<Set width( 100 ) ),
	Spacer Box( Size( 20, 10 ) ),
	Button Box( "Export",
		path = Pick Directory( "Select the folder to save .CSV file:" );
		aa = input << get text();
		
	)
	
);

exE = Concat( aa, exC );
save( path || "\" || exE );  /// 

Eval( Parse( "pref(" || current_pref || ")" ) );

topic Enter the file name and save in Discussions

Enter the file name and save

Re: Enter the file name and save