nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Or how to implement this simple substitution with JSL?

lwx228

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!

Accepted answers

David_Burnham

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", "" ) )
);

All comments

David_Burnham

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", "" ) )
);

lwx228

Thank Dave!

Formula( Substitute

lala

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!

Mark_Bailey

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, . );
);

lala

Good way, thank you!