Print Page | Close Window

Phone Number function

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=4592
Printed Date: 08-July-2025 at 6:24pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Phone Number function
Posted By: joshs
Subject: Phone Number function
Date Posted: 02-July-2011 at 5:40pm
Is there a sub function / function already built in the system to standardize or format phone numbers?

ie.
8669299626
to
(866) 929-9626

Josh


-------------
Josh Shirley
josh@windsurfutah.com


Replies:
Posted By: joshs
Date Posted: 02-July-2011 at 6:00pm
well, I guess it is not worth the time to search for:

Here is my edit to the stringfunctions.asp file:
///////////////////////////////////////////////////////////////////////////////////////////

'*****************************************************************************************************
'// Format display phone numbers
'*****************************************************************************************************
Function phoneformat(byVal phonenumber)

  phonenumber = Cstr(phonenumber)
  phonenumber = Trim(phonenumber)
  phonenumber = Replace( phonenumber, " ", "")
  phonenumber = Replace( phonenumber, "-", "")
  phonenumber = Replace( phonenumber, "(", "")
  phonenumber = Replace( phonenumber, ")", "")
  phonenumber = Replace( phonenumber, ".", "")
  phonenumber = Replace( phonenumber, ",", "")
  
  select case LEN(phonenumber)  
  Case 10
    tmp = tmp & "(" & mid(phonenumber,1,3) & ") "
    tmp = tmp & mid(phonenumber,4,3) & "-"
    tmp = tmp & mid(phonenumber,7,4)
  case 11
    tmp = tmp & mid(phonenumber,1,1) & " "
    tmp = tmp & "(" & mid(phonenumber,2,3) & ") "
    tmp = tmp & mid(phonenumber,5,3) & "-"
    tmp = tmp & mid(phonenumber,8,4)
  case else
    phoneformat = null
    exit function  
  end select
  
  phoneformat = tmp
end function
////////////////////////////////////////////////////////////////////////

So any place a phone number is listed this can be added:


phoneformat(scCompanyPhoneNumber) 'uses phone number listed by store settings.
or 
phoneformat("8669299626")

wah la




-------------
Josh Shirley
josh@windsurfutah.com


Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net