ed good morning....i did replace all dialednr with chrtran(dialednr,"-","")
and cleaned the database
the problem is that the harris pbx that spills thhe data into this database does it like this but they are fixing it right now...that database is made in betrieve..
i bhave another problemmm
it does not show anything on the grid
so now it has nothing to do with the dahes,,
the problem i think now is when there are incomplete callss like the person dialed 4 digits only and it hanged up...so it only recorder 4 digits in the database...
but there is another problem with that there ate calls like 911 or 411 calls made that they do need to be showed up in the screen..
now i have one customer that made 2 411 calls and those are the only ones whowing up..
can you please help me correct this.....i know tht is halfway working..
what i did on the view is i fileter all the dialednr that are in blank....we dont need them anyways...










>>ed good morning, its working, but it needs a litle work more..
>>for example call in a client thet is 411 calls...those do show upa at 0 dollars...thats goods.
>>im thinking....using chrtran(dialednr,"-","") that replaces visually the dahes with blank...but how do i doit fisically in the database...?i know thats the problem..
>>
>
>You know how to change the string, so all you have to do is save it; you have several things you could do, fixing the value before it's saved in the field would be one obvious solution, or at some point before processing the table after new records are added, you could use REPLACE to 'fix' the data fields. If the number of records involved in the table is large, you'd want to scope the REPLACE to only update records not previously processed, or if the number of records were fairly small (for example, if your import worked by pulling in new records to an intermediate file before putting them in their final resting place), something as simple as:
>
>USE MyImportTable
>REPLACE ALL dialednr WITH CHRTRAN(dialednr, "-", "")
>
>would fix the field content in all the records.