Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual dBase ... adding prefix to each cell.

Status
Not open for further replies.

sachit64

Technical User
Jul 14, 2005
1
CA
I have a large database of peoples phone numbers and I have to add the area code to every single phone number.

Is there any way to quickly do this? For example having wild characters.

REPLACE: ***-****
WITH: 613-***-****

Anything like that?
 
hi

I am assuming you have a .dbf file and know the name of the field in question. However, you will need to have dbase installed as this is the shell that will enable u to perform the operation.

From the command prompt...type...

USE my.dbf
REPLACE ALL myfieldname with "613-" + myfieldname

and its as simple as that

**********************************
There is more than one way to skin a cat...but who wants a skinned cat?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top