Replace text 1

[needmoremoney]

I have a phone number field (000)234-0000.
If there is no phone number then the output is ( ) -

Does anyone know how to write a formula to replace the "( ) - " with just a blank spot?

Thanks much.

My current formula is:

whileprintingrecords;
if not isnull ({EInfo.homePhone}) then {EInfo.homePhone} else "";

But this doesn't work. The "( ) - " still shows.

cystal reports 8.5

 

[lbass]

That's odd. Maybe try:

if {EInfo.homePhone} = "( ) - " then "" else
{EInfo.homePhone}

-LB

 

[Turkbear]

Hi,
If there is no phone number, where is the ( ) - coming from?


If it is in the data field, then the IsNull test will never be true..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[needmoremoney]

Thanks LB, but the same thing still shows. I think the field format was set to have the ( ) - .

Any other ideas let me know.

Thanks much..

 

[needmoremoney]

I forgot to mention, I'm pulling for an access 97 database.

 

[bdreed35]

Perhaps you could try this:

if trim(mid({EInfo.homePhone},2,3))=""
then ""
else {EInfo.homePhone}

~Brian

 

[needmoremoney]

Brian,

Thanks much. That's perfect. I gave you a star.. I just figured out how the star stuff worked here.

Thanks much.

 

[Turkbear]

Hi,
OK, Try avoiding using the actual field altogether:

@DoPhone
numberVar indx;
numberVar Lngth;
stringVar StrOut := "" ;
If {EInfo.homePhone}[2] not in ['0','1','2','3','4','5','6','7','8','9']
then
''
else

for indx := 1 to  Length(EInfo.homePhone})do
 (StrOut := StrOut + {EInfo.homePhone}[indx]);
StrOut

Assumes valid Phone numbers always have a number in the second spot ...

Use the formula and not the field for display..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
I need to type faster..Nice answer Brian..




To Paraphrase:"The Help you get is proportional to the Help you give.."