Replacing records

To replace a field, open Edit | Replace menu, or click Ctrl-R.

Replace dialog box opens.


Replace records in DBF File
  • Select the field in the Field drop-down list.
  • In the Search and Replace on edit boxed specify the symbols to be replaced.
  • Optionally check the Use records range box and specify First and Last records for replacement.
  • Check the Substring box if you want to replace not the whole field but the specified part of it.

For replacing the whole field, you may use a wild card.

The replace command can replace in memo fields.

Replacing via Command Line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" table.dbf /REPLACE:FldName:OldValue:NewValue [/CASE] [/SUBSTR]

Replacing Substring

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" table.dbf /REPLACE:Desc:2021:2022 /SUBSTR

Replacing only Upper symbols

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" table.dbf /REPLACE:Name:MIKE:MARK /CASE

Replacing with current date

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" table.dbf /REPLACE:Date:*:today()


DOWNLOAD NOW

Updated Fri, 22 Mar 2024

Back to DBF Viewer 2000 Home