topic Re: Or how to implement this simple substitution with JSL? in Discussions

Or how to implement this simple substitution with JSL?

lwx228 — Fri, 09 Jun 2023 23:29:34 GMT

For example, remove the "S" from all names in the "name" column of "Big class.jMP ".

Can do it directly by substitution?Can the new VERSION of JMP be implemented?
get looks like the "rename" column.

Thanks!

Re: Or how to implement this simple substitution with JSL?

David_Burnham — Thu, 18 Jun 2020 11:32:18 GMT

You can create a column formula to perform the substitution: Substitute(:name,"S","")

In code it would look something like this:

dt = Current Data Table();
dt = New Column( "New Name",
		Character,
		"Nominal",
		Formula( Substitute( :name, "S", "" ) )
);

Re: Or how to implement this simple substitution with JSL?

lwx228 — Thu, 18 Jun 2020 11:39:54 GMT

Thank Dave!

Formula( Substitute

Re: Or how to implement this simple substitution with JSL?

lala — Wed, 24 Jun 2020 07:05:08 GMT

How do you use JSL to perform the replacement operation to achieve this manual effect?

Replace column 2, "5" with null in a perfectly matched fashion, and "15" or "25" in this column are unaffected.

Thanks!

Re: Or how to implement this simple substitution with JSL?

Mark_Bailey — Wed, 24 Jun 2020 12:09:56 GMT

Numeric data should not pose a problem. See this example:

Names Default to Here( 1 );

dt = New Table( "Substitution",
	New Column( "Old Data", Numeric, Continuous ),
	New Column( "New Data", Numeric, Continuous )
);

:Old Data << Set Values( J( 50, 1, Random Integer( 3, 18 ) ) );

Wait( 2 );

For Each Row(
	:New Data = Substitute( :Old Data, 5, . );
);

Re: Or how to implement this simple substitution with JSL?

lala — Wed, 24 Jun 2020 12:18:54 GMT

Good way, thank you!