CleanDBF

can be easily customizable to work as

wpe1E.jpg (10648 bytes)

act.jpg (1444 bytes) ACTClean - clean up your ACT!

goldmine.jpg (1426 bytes) GoldClean - clean up your GoldMine

telemagic.gif (2200 bytes) TeleMagicClean - clean up your TeleMagic

dbase.jpg (1184 bytes) or any dBase or FoxPro compatible file fox.jpg (1122 bytes)

 

Cick here for SetUp

Only $59
Order Form

Download Free Demo
The Demo works works on the ACTDEMO.DBF file
and runs 10 times before prompting for payment.


Before DBFSweep

After DBFSweep - Contact names in Initial Caps

Next - Process Company, Address1, Address2, City, State


 

Next, you can choose to push the Suite's towards the top of the Addresses

This is just one of the many Preferences you can specify, where the Address3 field is closest to the City.
You could also specify that it should be in Address2 or Address1.  It is fully customizable.


You can convert the State Names in to the State Codes

Before - notice the State is written out

After - notice the State is now the 2 character State Code


GoldSweep! performs "sweeps" that make it unnecessary to buy other Add-Ons which only do a small part of what this product does.  For example, you can pay hundreds for software that fixes Area Codes when they change.  But this is just a simple "sweep" to replace one area code with another, that you can easily do with GoldSweep!

For example, the Sweep to change area code 515 to 641 would be:
Replace Phone with StrTran(Phone, '515', '641')

You will see in the top right corner 4 buttons which ask One Skip All Quit

One Replace just the one record you see at the top of the list of data records (safest option)
Skip Skip the one record you see at the top.  Do not replace. Leave as it is.
All Replace all the records you see in the list, without asking further
Quit Exit out, and do not replace any records

Explanation of terminology

Term Description

Example Before

After

Swap Exchange the values of two fields Address1: 123 Main Street
Address2: Suite 101
Address1: Suite 101
Address2: 123 Main Street
Move Move the values of one field in to, and overwriting another Address1: 123 Main Street
Address2: Suite 101
Address1:
Address2: 123 Main Street
Initial Caps Capitalize the first letter of each word Address1: 123 MAIN STREET Address1: 123 Main Street
Left Align Remove unnecessary spaces on the left Address1:           123 Main Street Address1: 123 Main Street
Respell Exchange one word for another Address1: 123 Main St. Address1: 123 Main Street
Switch Exchange the order of words Name: Smith, Joe Name: Joe Smith
Update Change a new value for an old value Phone: 515-472-5830 Phone: 641-472-5830

Includes
Mr. & Ms. Contact
Putting "Mr." or "Ms." Into your Contact Database

at no additional charge


Software Products


Creative Intelligence Software

 

.