LOVD Gene configuration area

Advanced edit features

Find & Replace
This feature, in LOVD 1.1.0 known as "Free edit", can be used to update large numbers of variant and patient records all at once. The find & replace form guides you to define which genes would you like to work on, which text you want to search for in what column, where in this field you want to have the search text match and which text it should be replaced by if it matches. This works for one field at a time only, so you can not set a certain reference for all mutations causing a certain phenotype, for instance. What you can do, is change all commas in a field to decimal dots, fix common typing errors, or replace a reference with a different one in all entries.

Warning Be extremely careful when using this function since misuse can empty an entire field in the database. It would be wise to do a download of the database first for backup purposes.

In the configuration area, click the "Find & Replace" link.
Select genes: Select which genes you want to apply this find & replace on. If you perform find & replace on a patient column, only the patients that have variants in the selected genes will be edited.
Apply find & replace to: Select the field you want to work with. This drop-down list shows all custom columns available in LOVD; if you select a column that is not enabled for the gene(s) you want to apply the find & replace to, no changes are done to the database.
Match type: Select how you want to search the selected field for the search value:
  • Field value is... the search string should match the field's contents exactly.
  • Field contains... the search string can be found anywhere within the field's value.
  • Field starts with... the field's value should start with the search string.
  • Field ends with... the field's value should end with the search string.
  • Field contains anything - obviously, in this case you do not need to provide a search string.
Find text: Fill in the search string that you wish to have replaced by the replace string.
Replace text: Fill in the replace string, the text value that you want to use to replace the matched search string with.

If all fields are filled in correctly, LOVD will first notify you about the number of entries that matched your find text and ask you if you want to continue. After your confirmation, LOVD will do the find & replace and notify you of the number of matched entries and the number of replaces performed.

Find & replace does not have an undo. So be extremely careful with what you do. If you make an error while using the form, you may lose important data from the selected column.

« Advanced edit features Copy Column »

Last modified 2014/08/25 14:48:31 CEST

When using or discussing LOVD please refer to:
Fokkema IF, Taschner PE, Schaafsma GC, Celli J, Laros JF, den Dunnen JT (2011). LOVD v.2.0: the next generation in gene variant databases. Hum Mutat. 2011 May;32(5):557-63.

LOVD has received funding from the European Community's Seventh Framework Programme
(FP7/2007-2013) under grant agreement nº 200754 - the GEN2PHEN project.
Leiden University Medical Center, Netherlands
Ing. Ivo F.A.C. Fokkema, Dr. Johan T. den Dunnen