topic Re: How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits" in Discussions

How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits"

HyeonRyeolCHO — Wed, 05 Jul 2023 10:31:01 GMT

Hi ALL.

I am coder and work for OSAT industry.

i am trying to make JSL script.

i succeed getting Column Property "Spec Limits" But it come as List.

when i get List"Spec Limits" element in order to get value of LSL & USL, the elements type is Name. ( I am not get used to this type & JSL language)

when i try to convert this Name type to String, i couldn't find function(As String).

Q1. is there any function can convert type Name to String?

Q2. If there is no fucntion, how can i parse LSL,USL value from column property "Spec Limits"?

dt = Data Table( "ABC.stdparametric" );
dt << Add Rows( 2, 0 );
number_of_columns = N Col( dt );
//------------------------------------------------------------
start_point = 1; // Initialze the start-point variable. and looking for where testItem start.
For( j = 1, j <= N Col( dt ), j++,
	colName = Column( dt, j ) << Get Name;
	If( colName == "ATR_Present",
		start_point = j; // Assign the column index if the name matches
		Break(); // Exit the loop after finding the first occurrence
	);
);
start_point = start_point + 1;
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --For( i = start_point,
	i <= number_of_columns, i++, // from 28-boone;
	columnIndex = 50;
	columnName = Column( dt, columnIndex ) << Get Name;

// Get the specification limits from column
	specLimits = Column( dt, columnIndex ) << Get Property( "Spec Limits" );
	lsl = specLimits[1];
	usl = specLimits[2];
	usl_value = Eval( Parse( usl ) );  // not working

	lsl_value = Eval( Parse( lsl ) );  // not working
	dt:columnName[1] = lsl;
	dt:columnName[2] = usl;
);

Re: How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits"

txnelson — Wed, 05 Jul 2023 11:22:41 GMT

Here is a simple example that shows how to retrieve the numeric value of the LSL and USL from the retrieved Spec Limits List

names default to here(1);
dt=open("$SAMPLE_DATA/semiconductor capability.jmp");

specLimits = column( dt, "NPN1" ) << get property( "Spec Limits" );
usl_value = specLimits["USL"];
usl_value = specLimits["LSL"];

There are also some JSL features that will simplify your code. Below is a modification of your script that you may find advantageous.

dt = Data Table( "ABC.stdparametric"  );
dt << Add Rows( 2, 0 );
number_of_columns = N Col( dt );
//------------------------------------------------------------
/*start_point = 1; // Initialze the start-point variable. and looking for where testItem start.
For( j = 1, j <= N Col( dt ), j++,
	colName = Column( dt, j ) << Get Name;
	If( colName == "ATR_Present",
		start_point = j; // Assign the column index if the name matches
		Break(); // Exit the loop after finding the first occurrence
	);
);*/
columnNames = dt << get column names( string );
start_point = Contains( columnNames, "ATR_Present" ) + 1;
//start_point = start_point + 1;
//------------------------------------------------------------
For( i = start_point, i <= number_of_columns, i++, // from 28-boone;
	//columnIndex = 50;
	//columnName = Column( dt, columnIndex ) << Get Name;

	// Get the specification limits from column
	specLimits = Column( dt, columnNames[i] ) << Get Property( "Spec Limits" );
	/*lsl = specLimits[1];
	usl = specLimits[2];
	usl_value = Eval( Parse( usl ) );  // not working

	lsl_value = Eval( Parse( lsl ) );  // not working
	dt:columnName[1] = lsl;
	dt:columnName[2] = usl;*/
	Column( dt, columnNames[i] )[1] = specLimits["USL"];
	Column( dt, columnNames[i] )[2] = specLimits["LSL"];
);

Re: How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits"

jthi — Wed, 05 Jul 2023 10:53:52 GMT

Here are some options

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

specs = Column(dt, "NPN1") << Get Property("Spec Limits");
// lsl_val = Arg(specs[1], 1);
// usl_val = Arg(specs[2], 1);
lsl_val = specs["LSL"];
usl_val = specs["USL"];

Re: How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits"

Craige_Hales — Wed, 05 Jul 2023 11:30:26 GMT

The other answers are the ones you really want, but the answer to converting names to strings is the char() function which will make some sort of string out of any JSL type.

e = Expr( xyzzy );
Show( Type( Name Expr( e ) ) ); // Type(Name Expr(e)) = "Name";
Show( Char( Name Expr( e ) ) ); // Char(Name Expr(e)) = "xyzzy";

Re: How do i convert Type'Name" to String in order to get value of Column Property"Spec Limits"

HyeonRyeolCHO — Thu, 06 Jul 2023 00:25:13 GMT

Thanks Jim.

the solution helped me a lot.

i will study more about how to treat list & element.