Automate office tasks with VEDIT

Working with Databases

Choose one of the following examples:

Strip white spaces
Convert tabs
Processing files

Office Automation:

Transfer data
Databases
Create email lists

Order (Secure)

Return Home

Although VEDIT cannot readily work with raw database files (other than xBASE), most database programs let you export a table as a text file which VEDIT can then manipulate. Here are some examples.

You may find that some phone numbers in your database are entered as (555) 555-5555 while others are entered as 555-555-5555 or 1-555-555-555. Lets say you need them all in one format.
1. Export the table to a text file and open it in VEDIT.
2. Two search & replace commands will correct the telephone numbers. Save the file.
3. Import the text file and use it to replace the existing table.

You may find that your database has duplicate records that you want to delete.
1. Export the table to a text file and open it in VEDIT.
2. Sort the file based on the field which indicates the duplicate records.
3. A search & replace with "regular expressions" can delete the duplicated records (after sorting). Save the file.
4. Import the text file and use it to replace the existing table.

This "export", "fix with VEDIT" and "import" technique can be used with any database manipulations that are difficult or impossible to perform with the database program.

Please contact us with any sales or technical questions at:

Mailing address:	Greenview Data, Inc. PO Box 1586, Ann Arbor, MI 48106 USA
Phone (Sales):	In US and Canada call Toll-Free 1-800-458-3348
Phone:	Otherwise, please call (734) 996-1300
Fax:	(734) 996-1308
E-mail:	sales@vedit.com or support@vedit.com

Top of Page | VEDIT text editor (Home) | Anti-spam service | Contact | Privacy