DBF Viewer 2000
DBF Viewer 2000 Online Help Prev Page Prev Page
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
How to purchase
Top  Previous  Next

Replacing records in DBF File

for FREE

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:2017:2018 /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()

for FREE

Updated Thu, 08 Apr 2021

Back to DBF Viewer 2000 Home

Page top | Contacts | Copyright © HiBase Group, 2002-2021