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,
You should be able to do it by copy/paste functionality in grid view or in table widget.
- Copy a single value you want to paste into all columns to the clipboard.
- 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.
- Paste (Ctrl+V). All values in selected cells will be replaced by the clipboard content.
Hope it helps. Otherwise feel free to ask more.
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.
Am using 14.10.13 64bit on Win 7 64bit,
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
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
Thanks, but I don't feel comfortable with using that. I guess I will use excel instead.
David, is sql-statement realized only by connecting to the schema through the "Services"?
or now it can be realized in a query builder?
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