Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing data
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00397119
Message ID:
00397131
Views:
12
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform