Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing data
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00397119
Message ID:
00397131
Vues:
14
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform