Alphanumeric Phone Format?

[Kimmie]

Hi All,

I have the standard calculation in my database for a phone number:

Let (

//define variables:

[

rawNumber = Filter (Phone; "0123456789") ;

length = Length (rawNumber);

red = RGB (160;0;0);

//set error flag for a phone number that's too short

error = If ( length < 10 ; TextColor ("error: " & Phone; red); "")

];

// now apply the phone formatting and return resuilts

If ( error ≠ ""; error;

"(" & Left (rawNumber; 3) & ") " & Middle ( rawNumber; 4; 3) & "-" & Middle ( rawNumber; 7; 4) &

// this condition tests for extra digits that we'll treat as an extension

If ( length > 10; " x" & Middle (rawNumber; 11; length - 10); "")

)

)

How can I tweek this calculation to also format a 10 character alphanumberic phone number? I have many companies that have Toll free alphanumeric numbers ie 800-THE-BOMB. Any help would be appreciated!

Thanks,

Kim

[Genx]

Change this line:

rawNumber = Filter (Phone; "0123456789") ;

To:

rawNumber = Filter (Upper(Phone); "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ") ;

Edited February 17, 2009 by Guest

[Kimmie]

Hi GenX,

I replaced the line, didn't get an error but it didn't format it to (###)AAA-AAAA.

[Genx]

Works fine for me.