RegExp Pattern

Hi MB,

I don't use RegExp, personally, but I'm assuming this is the US phone number bit:

Please Login or Register  to view this content.

My best guess would be to replace that with:

Please Login or Register  to view this content.

Yes that is the USA Phone number string and the parsing works well tell I figure out it dropped all the none USA company, as parsing blocks of 55,000 line. I need the RegExp to try all three types of number and parse than just pasre one style.. I will see about posting sample just USB at work now. Trying to setup loop to do each style

MB

Hi MBCMDR
could you test it before Execute

Please Login or Register  to view this content.

just add your patterns to the array

Hello MB,

Been out of town working on other projects. Here is the RegExp Statement to check for either US or UK phone numbers.

Please Login or Register  to view this content.

Boy I'm glad someone knows RegExp. To me, that pattern looks like what I yell when I stub my toe.

Hello Paul,

I like that description. Regular Expressions are pretty much a language all their own. People have written books on how to use them.