Re-format Fax Number

I am looking for a way to reformat - by means of a custom formula or something else - a fax number in Sforce that looks like this:

(248) 258 0000

into a text string like this:

12482580000

Any suggestions?

Eric Fris

ericfris@corporategrowthservices.com

April 28, 2009
·
Answer
·
Like
0
·
Follow
0

Ira
VB6 Code
[code]

For f = 1 to Len(Fax_number)
    If IsNumeric(mid$(Fax_number,f,1) then
        Temp$ = Temp$ & mid$(Fax_number,f,1)
    End If
Next

[/code]

Or

[code]

Temp$ = Fax_number

Temp$ = Replace(Temp$, "(" ,"")
Temp$ = Replace(Temp$, ")" ,"')
Temp$ = Replace(Temp$, "-" ,"")
Temp$ = Replace(Temp$, ".", "")

[/code]

January 16, 2010
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Re-format Fax Number

You need to sign in to do that.