Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a phone number inside a string
Message
From
05/06/2008 14:36:23
 
 
To
05/06/2008 13:42:20
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:
01321938
Views:
16
How about something like:
? IIF(LEN(ALLTRIM(SUBSTR(x,RAT('-',x)-3)))>0,'y','n')
>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
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform