Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a phone number inside a string
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01321918
Message ID:
01321923
Views:
21
>>I need to determine if any combination of numbers formatted like this: 999-9999 is within a string. The string may have (999)999-9999 or 999-999-9999 or anything else, but it will always have 999-9999 (123-1234, 987-321-9382, etc). Any way to do that? Perhaps the string is:
>>
>>Examples:
>>
>>Suite 100 123-1234  && .t. because it contains 123-1234
>>Bldg J (910)222-2222  && .t. because it contains 222-2222
>>
>
>Convert all numbers to digits 9 and then check.
>
>With simple chrtran()
>
>lcNumbers = '0123456789'
>
>lcNewString = chrtran(m.lcString,m.lcNumbers, replicate('9',10))
>
>? "999-9999" $ lcNewString
Very cool!
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform