Phone number regular expression

[AutomationNinja 194]

Lets say I have a list of phone numbers,

 

 

http://screencast.com/t/v8JBYdg6

 

 

How would I extract just the phone numbers from that list.  I tried \\(?\\b[0-9]{3}\\)?[-. ]?[0-9]{3}[-. ]?[0-9]{4}\\b but no dice.

 

Tried with columns, variables and list to list. Not sure where I am going wrong with this.

 

add list to list(%phone, $find regular expression($text from list(%list, $new line), "\\(?\\b[0-9]{3}\\)?[-. ]?[0-9]{3}[-. ]?[0-9]{4}\\b"), "Delete", "Global")
 

All tips appreciated

 

Thanks,

 

Rob

[pftg4 102]

found this

 

^(??:\+?1\s*(?:[.-]\s*)?)?(?:\(\s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])\s*\)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\s*(?:[.-]\s*)?)?([2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})\s*(?:[.-]\s*)?([0-9]{4})(?:\s*(?:#|x\.?|ext\.?|extension)\s*(\d+))?$

[AutomationNinja 194]

No luck with that either. Here is the code I am using:

 

add item to list(%list, $scrape attribute(<tagname="strong">, "innertext"), "Delete", "Global")
 

add list to list(%phone, $find regular expression($text from list(%list, $new line), "^(??:\\+?1\\s*(?:[.-]\\s*)?)?(?:\\(\\s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])\\s*\\)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\\s*(?:[.-]\\s*)?)?([2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})\\s*(?:[.-]\\s*)?([0-9]{4})(?:\\s*(?:#|x\\.?|ext\\.?|extension)\\s*(\\d+))?$"), "Delete", "Global")
 

and the url http://www.lawyers.com/consumer-law/california/all-cities/law-firms-p.html?N=0&r=0&sort=0

[pftg4 102]

here you go 

 

 

 

 

add list to list(%test, $page scrape("<strong class=\"info_phone\">", "</strong>"), "Delete", "Global")

 

 

Pftg4

[UBotBuddy 331]

Did you look at these tuts?

 

http://ubottraining.com/regex/extracting-phone-numbers/

http://ubottraining.com/regex/reformatting-phone-numbers/