Skip to content

INTLPHON

Returns formatted phone number for US names and unformatted number for International names.

Reporting Area(s)

Names, Instructor

Required Parameters

  1. Phone number field (nmdphone, nmhphone, nmdphone)
  2. Country field (nmcntry)

Optional Parameters

  1. Character return value: text label for phone field (i.e. "Home: " or "Wk: ", or "Fax: ")
  2. Character return value: suffix added to all international phone numbers (i.e. "Int'l")

Example(s)

INTLPHON(nmdphone,nmcntry) returns number formatted for US for US, Canada, and Puerto Rico [i.e. (555) 555-5555]. Returns unformatted number for other countries (i.e. 5555555555)

INTLPHON(nmdphone,nmcntry,"Day: ") returns number and label [i.e. Day Phone: (555) 555-5555--US/Canada; Day: 5555555555-International]

INTLPHON(nmdphone,nmcntry,"Day: ","Int'l") returns number, label, and suffix if phone is international [i.e. Day: (555) 555-5555--US/Canada; Day: 5555555555 Int'l-International]

SHOWPHON