Fast way to replace selected entries with a new value

[#1]

A user selects some rows and a column and wants to replace the selected entries with a new values via the GUI.

names default to here(1);
colname = "column with values between 1 and 10";
dt = new table("test", add rows(5000000), new column ("c",Character,  set each Value(Char(random integer(10)))));
dt << Select Where( :c == "7" ) << select columns (1);
newname = "column with values between 1 and 10, 7=X";
newvalue="X";
:c << set name( newname);

The score is based on time. Every click, every keystroke, every double click and every calculation counts in fractions of a second.

[#2]

Copy & Paste

[#3]

linked Subset: type & Fill to end

It takes forever—better make sure you’ve got a full pot of coffee ready!

[#4]

Name Selection in Column:
It's accessible right via the column header - sooo cool!
I am sure there is a hidden trick to pick THE selected column as the target column - but I did not find it yet ...

[#5]

Name Selection in Column - with an auxiliary column:

[#6]

Why not Recode?

It works fine for simple replacements. However, in general, the selected rows won't correspond to a specific value in the target column.
So, the demo case is not ideal. Sorry.

[#7]

And how to select rows? -> take care there are no variable inside the search expression !