Search the Community

I'm trying to figure out how to write a phone formatting rule that will allow for this format: 336 876 9876 I was trying this out below but had some issues if an extension was present or if there was no area code. I'm completely in the dark when it comes to coding! HALP:) var str = Field("Phone");//Phone var newStr = str.replace(/\s+/g, ''); return Left(newStr,3) + " " + Left(Right(newStr,6),3) + " " + Right(newStr,4); Thanks in advanced! Hilary

I am using the Telephone Format Rule to return the word "Tel:" plus the phone number. I only want the tag line "Tel:" to have a horizontal scale of 80%. The actual phone number should not have any scaling applied (100%). When I use the rule below and preview in FusionPro, the entire line is scaled 80% - the word "Tel:" AS WELL AS the phone number. Can't figure out what I am doing wrong. Is this a bug? Using FusionPro 9.0.3, Acrobat X Pro 10.1.7 and Windows 8 Pro. // Rule-Tel1 // Formats Phone Number var formatStyle01 = "$1.$2"; //simple 7 digit phone var formatStyle02 = "$1.$2.$3"; //simple 10 digit phone var formatStyle03 = "$1.$2.$3.$4"; //10 digit phone starts with 1 var formatStyle04 = "$1.$2.$3 ext.$4"; //10 digit phone with extension var formatStyle05 = "$1.$2.$3.$4 ext.$5"; //10 digit phone starts with 1 with extension var formatStyle06 = "$1.$2 ext.$3"; //7 digit phone with extension var thisNumber = Field("Tel1"); if (thisNumber == "") return ""; else return '<magnify type=setwidth factor=80>Tel:</magnify><t>' + formatNumber(Trim(thisNumber)); ////////////////////////////////////////////////////////////////////////////////////////////////////// // DO NOT EDIT BELOW THIS LINE /////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////// function formatNumber(number01) { var pattern01 = /^(\d{3})[^\d]*(\d{4})$/; // 2201727 or 220-1727 or 220- 1727 var pattern02 = /^[\D]*(\d{3})[\D]*(\d{3})[\D]*(\d{4})$/; // 8002201727 or 800-220-1727 or (800)220-1727 or (800) 220-1727 var pattern03 = /^\+?(\d{1})[\D]*(\d{3})[\D]*(\d{3})[\D]*(\d{4})$/; // 18002201727 or 1-800-220-1727 or +1 (800) 220-1727 var pattern04 = /^[\D]*(\d{3})[\D]*(\d{3})[\D]*(\d{4})\D*[Xx\.\-\+\*#Nn]\D*(\d+)$/; // 800-220-1727 ext 12345 or (800) 220-1727 ext 12345 var pattern05 = /^\+?(\d{1})[\D]*(\d{3})[\D]*(\d{3})[\D]*(\d{4})\D*[Xx\.\-\+\*#Nn]\D*(\d+)$/; // 1-800-220-1727 ext 12345 or +1 (800) 220-1727 ext 12345 var pattern06 = /^(\d{3})[\D]*(\d{4})\D*[Xx\.\-\+\*#Nn]\D*(\d+)$/; // 2201727 ext 1234 or 220-1727 ext 1234 or 220- 1727 ext 1234 var patternEndExt = /(.)[Xx\.\-\+\*#Nn](.)/; var patternStart1 = /^[\D]*[1]/; if(number01.match(pattern01)){ number01 = number01.replace(pattern01, formatStyle01); return number01; } else if(number01.match(pattern02)){ number01 = number01.replace(pattern02, formatStyle02); return number01; } else if(number01.match(pattern03)){ if (number01.match(patternStart1)){ number01 = number01.replace(pattern03, formatStyle03); return number01; } else { return number01; } } else if(number01.match(pattern04)){ number01 = number01.replace(pattern04, formatStyle04); return number01; } else if(number01.match(pattern05)){ number01 = number01.replace(pattern05, formatStyle05); return number01; } else if(number01.match(pattern06)){ number01 = number01.replace(pattern06, formatStyle06); return number01; } else { //return "no match any pattern"; return number01; } }

We have a client we are building a new Marcomm Central Storefront for that has office worldwide. A few of the items that will be on the site are stationery (business cards, letterhead, envelops, etc.). The items with phone numbers need the phone numbers formatted for international numbers. Ex: +44 7891 549 692. The Phone Number Format Rule in Fusion Pro only has formats for domestic numbers. Have any of you written a rule to format international phone numbers? If so, will you share it with me? If not, have you run into this situation before and resolved it a different way? If so, will you share that with me? Thanks!