Search and Replace Data

What does Search and Replace Data do?

After filling in and selecting a number of data, it searches for the input value in the entire database and you can replace it with another value.

 

SirkelData Search and Replace Data overview and list

PossibilityActionResults
SirkelData - Search Replace Data - Check AllAll possibilities - tick tables in the list.SirkelData - Search Replace Data - Tables
SirkelData Data Search Replace Clear Selection ButtonNo options - check tables in the list.SirkelData Search and Replace Data Remove All in List
SirkelData - Search Replace Data - Find TableFind table in the list. 
SirkelData - Search Replace Data - ValueEnter the value that will be searched for in the selected table(s). 
SirkelData - Search Replace Data - TypeSpecify the type (numeric or text) to be searched for. 
SirkelData - Search Replace Data - Like

If text is selected, indicate what kind of LIKE will be used in the SQL.

Selections you can make are:

  • Find the exact value
  • Finds any values that start with input.
  • Finds any values that end with input.
  • Finds any values that have input in any position.
 
SirkelData Search and Replace Data Search Value ButtonLook up the value entered in the selected table(s). 
SirkelData - Search Replace Data - ClearClear the value and selected options. 
SirkelData - Search Replace Data - Row Start EndNumber of rows that have the input value. Afterwards you can adjust the rows for a possible update. 
SirkelData - Search Replace Data - New ValueThe new value you can define. 
Fill in the new value in the grid. 
SirkelData Search and Replace Data Update Data ButtonRun the updates. 
SirkelData Close ButtonClosing the window. 
SirkelData - Search Replace Data - Results GridResults of the updates. Here you have the option to individually update or delete a selected value. 
SirkelData Data Search Replace Update Logs TabIf you click on the 'Update Logs' tab, the results after one or more update(s) are displayed in a table.
SirkelData - Search Replace Data - Print PreviewGenerate a print preview of the results in the table. 
SirkelData - Search Replace Data - Export ToSelect the type in which the results are saved. 
SirkelData - Search Replace Data - Save ResultsSave the results in the chosen type.