I can't even do this simple replace!

[#1]

Not found in the script index, please finish with JSL.Thank you very much!

[#2 · Accepted solution]

You could use data table subscripting:

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Wait(3);
maleRows = Loc(dt[0, "sex"], "M");
dt[maleRows, "sex"] = "boy";

[#3]

It seems to be quite different from the VBA approach.thank you!

[#4 · Accepted solution]

I've tried to write JSL in a way that only works with perfectly matched substitutions, but if you don't want to replace only a few characters, how do you write JSL?Thank you!

[#5 · Accepted solution]

This is one way to do it

dt = Current Data Table();
dt:class[dt << get rows where( dt:class == "A1" )] = "A9";

[#6]

If this is the new case, this JSL is not very efficient.Can the code be improved for the new instance?Thank you!

[#7]

If I understand correctly, consider using the 'Match()' JSL expression. I generated the code below by using 'Cols > Recode':

and inspecting the JSL for the resulting formula column. And, 'yes', JSL is very different from VBA. You should look at 'Help > Books > Scripting Guide' and/or consider some training.

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Wait(3);
dt << New Column( "Age 2",
					Character,
					"Ordinal",
					Formula(
						Match( :age,
							12, "Twelve",
							13, "Thirteen",
							14, "Fourteen",
							15, "Fifteen",
							16, "Sixteen",
							17, "Seventeen",
							Format( :age, "Fixed Dec", 5, 0 )
						)
					)
				);

[#8]

I'm so sorry!Maybe the example I gave is not appropriate and misleading.

I just want to replace some of the specified characters with others in the same column.That is the manual interface function, just want to use JSL implementation.

The VBA implementation in excel is simple:Selection.Replace What:="1", Replacement:="9", LookAt:=xlPart

I just want the effect of this simple trade effect.But I don't have the corresponding code in JSL.Thank you!

[#9]

This is the result of the substitution in the case of "Match entire cell value" the multiple checkbox is not selected.Thank you!

[#10]

It's just a matter of replacing some characters in a cell with JSL.