The problem is that the phone numbers do not have dashes in them, which i need. Is there anyway to insert dashes after the data is already in the table? I tried using the input mask (set to 999-999-9999), and it put in dashes, but cut off digits.Try this:
Note: this assumes that all the phone_num fields will all have the area code.
STUFF(STUFF(phone_num,4,0,"-"),8,0,"-")
The other problem is that the minutes in the call detail record are in a format where a decimal is assumed (example 14 would be 1.4 minutes). Is there a way I can change all of them once they are in a foxpro table so they show the decimal? Maybe like multiply all records in the minutes field by .1 ? As long as there is only one decimal place assumed, that should work
Insanity: Doing the same thing over and over and expecting different results.