Office Task Automation Revision as of 15:57, 20 February 2017 by ToddAdmin (Talk | contribs) (Created page with "<seo title="Office Task Automation | vEdit" description="Easily use vEdit's flexibility to assist with many office task that do not even involve editing, such as transferring...") (diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

vEdit is much more than just an "editor", It is a flexible tool that can assist with many office tasks that have nothing to do with "editing".

• Assistant in transferring data between databases and accounting programs.
• Clean up databases, extract data from databases, perform search & replace operations on a database.
• Extract all valid email addresses from log files. Sort the email addresses and remove all duplicates.
• Extract the text (e.g. form data) from a web page, removing all HTML codes.

The typical approach to automation is to write complex programs in Visual Basic or C++. With vEdit's powerful search and replace capabilities, columnar block operations, many ready-to-use macros, and automation features can perform many tasks without any programming. Some tasks may require custom "macros"; the advantage with vEdit is that these macros often consist of only a few search and replace commands.

vEdit's search & replace is exceptionally powerful and fast. It supports both "pattern matching" and "regular expressions". A few search & replace commands can often perform the equivalent of a 100+ line Visual Basic or C++ program.

The following is an overview of how vEdit can assist with the example tasks mentioned above. It is not intended to be a step-by-step guide. Hopefully you will see how vEdit can help with your specific needs.

Transfer Data Between Databases and Accounting Programs

Most databases and accounting programs have "export" and "import" functions, which "in theory" makes it possible to transfer data between them. However, in practice the "export" format and the "import" format are often incompatible.

For example, the export and import formats might be:

Export: James Phillips    201 Fairview    Miami  FL  33120  110301
Import: "110301","James","Phillips","201 Fairview","Miami","FL","33120"

A single search & replace in vEdit using "regular expressions" can convert the "export" format to the required "import" format. You could easily create a batch file or Windows icon to fully automate the conversion.

For more complex conversions, you might use vEdit's extensive "columnar" block operations. You can delete, insert, copy, move, fill and sort columns of data.

Working with Databases

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.
3. Save the file.
4. 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. ort 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).
4. Save the file.
5. 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.

Working with Email Addresses

vEdit includes several ready-to-run macros that can really help when working with e-mail addresses.

E-EMAIL.VDM

Extract all "From:" and "Reply-to:" e-mail addresses from an e-mail archive file, sort them and remove duplicates. Works well with Eudora .MBX files.

E-XTRACT.VDM

Extract all e-mail addresses from a data or log file, sortthem and remove duplicates.

EXTRACT.VDM

Extract all records (lines) from a file which contain a specified search string. You can even automatically extract records (lines) from entire groups of files. For example, you could extract all "@aol.com" addresses. This macro also has many database uses and is available from the menu function MISC > More macros > Extract.

REM-LINE.VDM

Remove all lines in a file which contain a string listed in a file of "remove strings". Works well for comparing two lists of items (e.g. email addresses) - creates a file of the different items and a file of the common items. The next example uses this flexible macro.

Other Resources

• Automation Section
• Automation Overview
• Wiki Home