Replacing records

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

Replace dialog box opens.

• 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()

Back to DBF Viewer 2000 Home