Adding the same text to multiple rows in IJC.

Hello,

I have an empty text field in a IJC database that I wish to fill with text.

Is it possible to add the same text to all the rows from a structure search, rather than enter the text individually or copy and paste the text to different rows.

I suppose the action would be to fill all rows in the list with the same text, rather like AutoFill in Excel.

Thanks and regards,

Tim Ritchie.

Greetings Tim,

You should be able to do it by copy/paste functionality in grid view or in table widget.

1. Copy a single value you want to paste into all columns to the clipboard.


2. Select cells which should have this value. Or if you have applied list before, therefore shown records are only those in a list. Click on the column in table header -> the field will be selected in all rows.


3. Paste  (Ctrl+V). All values in selected cells will be replaced by the clipboard content.

Hope it helps. Otherwise feel free to ask more.

Regards,

Filip

Hello Filip,

Thanks for the help.

Regards, Tim.

I get a "Data in clipboard does not match the selection area" 

(i.e. a single line of e.g. text works to paste into one cell, but not multiple ones)

What exact version are you using? I will investigate.

David

Am using 14.10.13 64bit on Win 7 64bit,

Hello,

I have investigated the problem and it seems as a bug from our part. I have created a bug report and we will look into the problem. 

Meanwhile as a dirty workaround, what could be done is to use the SQL command to fill the desired rows with whatever value you need to. But keep in mind that using the SQL command instead of copy/paste beats the usability purpose of copy/paste and also that you have to be absolutely sure about what you are changing in the table and must use the sql responsibly.

update YOUR_TABLE set YOUR_FIELD = 'value_to_paste' where ID_COLUMN between valueFOO and valueBAR

For example:

update PUBCHEM_DEMO set TestField = 'paste this text' where cd_id between 1 and 20

This example command would put text "paste this text" to TestField column on table named PUBCHEM_DEMO only for the first 20 rows.

 

I am sorry for the inconvenience

Bests

David

Thanks, but I don't feel comfortable with using that. I guess I will use excel instead.

Hello,

David, is sql-statement realized only by connecting to the schema through the "Services"?

or now it can be realized in a query builder?

Bests

Igor

Hello Igor,

all of the sql commands are run through the "Services" and the built in SQL editor. Or if you have some other SQL editor available (such as http://squirrel-sql.sourceforge.net/ or similar), you can use those too.

Wishing all the best

David