Assuming you have the phone numbers coming in to you in this fashion, I
like to use regular expressions to break them up. Given the possible
formats that you listed, this might work for you. It's a bit rough, but
it should work. Just make sure you have the "treat as tagged text" checked
for the line break. You can change the separator character to anything
you like in the sepChar variable.
var phoneNum = Field("yourPhoneField");
var regMatch = /^\S?(\d{3})\S?\s?(\d{3})\D(\d{4})/;
var sepChar = ".";
if (phoneNum.search(regMatch)>=0){
var areaCode = phoneNum.match(regMatch)[1];
var firstThree = phoneNum.match(regMatch)[2];
var lastFour = phoneNum.match(regMatch)[3];
return areaCode + '<br/>' + firstThree + sepChar + lastFour;
}else{
return "Not a valid phone number.";
}
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--