I imported a database from Q&A into my new Sesame database. However through the transfer the Phone # and Fax # files got messed up.

The numbers transferred over w/out any () or - in the #. I tried doing a mass update with the code

Phone #= "(" + @Left(Phone #, 3) + ")" + @Mid(Phone #,4,3) + "-" @Right(Phone #, 4)  

and it didn't work, somehow, all it did was put double parenthesis in the front and it deleted the whole mid section.

I want to change it so that the numbers look like (555)555-5555. I don't know how to do this. I can either do something with importing them one more time. Or I can do another Mass Update .

If someone could help that would be wonderful. Thank you all for your help!!!

I tried the code, but it says "Statement or End-of-File expected." so something is wrong. I did a mass-update with that code on the Phone # field. Maybe it was me, I am really lost here and don't understand why this isn't working. Help!
Thanks!! 

The above will work with Mass Update and reformat the existing records as per your need. However, when you enter the phone number while adding new records, you want to have it reformat as per your need. The following code will help you doing just that. I believe this code was offered by Bob Scott in the earlier posting.

// Formats Telephone Number

var vHPhone as String      
var vNewHPhone As String  
var vhphonecount  
var vhpnentered

Vhpnentered = @num(HomePhone)
// Writeln(Vhpnentered)  
 
vhphonecount = @num(@len(vhpnentered))
//writeln(vhphonecount)

If vhphonecount = "10"  


{
vHPhone = @Num(HomePhone)  
vNewHPhone = "(" + @Left(vHPhone, 3) + ") " + @Mid(vHPhone, 4, 3) + "-" + @Right(vHPhone, 4)  
HomePhone = vNewHPhone  
}
else
{
Writeln("The Telephone Number needs to be Exactly 10 Digits")
  Writeln("The numbers you entered: " + @num(Homephone))
  Writeln("is : " + Vhphonecount + " Digits Please check Home Telephone and Re-enter")
 
}  

<interjecting some technical info to help while you work on this>
The LENID... stuff does not mean you've done something wrong.  We allow certain characters in element names, like spaces, by quietly legalizing the element name. You are seeing that legalized name in the error message. This is not, in itself, the error, and you don't need to worry about it.

DNolan,

You have a bunch of mismatched parentheses. The error you are seeing indicates a syntax error in your code. Here is a version that will compile:

PhoneNumber = "(" + @Left(@STR(PhoneNumber), 3) + ")" + @Mid(@STR(PhoneNumber), 4, 3) + "-"  + @Right(@STR(PhoneNumber), 4)