topic Fast way to replace selected entries with a new value in Discussions

Fast way to replace selected entries with a new value

hogi — Wed, 03 Dec 2025 22:45:03 GMT

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.

Re: Fast way to replace selected entries with a new value

hogi — Wed, 03 Dec 2025 22:53:08 GMT

Copy & Paste

(view in My Videos)

Re: Fast way to replace selected entries with a new value

hogi — Wed, 03 Dec 2025 22:59:28 GMT

linked Subset: type & Fill to end

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

(view in My Videos)

Re: Fast way to replace selected entries with a new value

hogi — Thu, 04 Dec 2025 08:26:57 GMT

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 ...

(view in My Videos)

Re: Fast way to replace selected entries with a new value

hogi — Wed, 03 Dec 2025 23:17:54 GMT

Name Selection in Column - with an auxiliary column:

(view in My Videos)

Re: Fast way to replace selected entries with a new value

hogi — Thu, 04 Dec 2025 08:29:23 GMT

Why not Recode?

(view in My Videos)

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.

Re: Fast way to replace selected entries with a new value

hogi — Wed, 03 Dec 2025 23:37:10 GMT

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

(view in My Videos)