![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#10
|
|||
|
|||
|
Hi All,
My application has evolved. Earlier I was searching for a string, such as 3.2.P.1.2.3, where the (period + number) after the "P" may repeat one or more times. Now, it can be: [2 or 3] + [period or no period] + [1 or 2 or 3] + [period or no period] + [P or S or A] + [period or no period] + [number], where the period (or no period) + number after the P,S or A may repeat any number of times. Some examples would be: 3.2.P.1 2.3.S.1.2 3.2.A.1.2.3.4.5 32P1 23S12 32A12345 I thought the expression would be "<[32].[231].[PSA].[0-9]{1,}"; however, this is only picking up strings that have periods in them. I thought the periods in this expression would represent any (or no) character. Would you help me with the expression, please? Thanks again, Roy |
| Tags |
| wildcard searches |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Check if a string is part of an array (containing wildcards...) | jodecaesteker | Excel Programming | 3 | 02-02-2018 10:56 AM |
Wildcards: searching for multiple words / expressions close to each other
|
ballpoint | Word VBA | 7 | 11-09-2017 03:30 PM |
| Searching for string on a formula | AMD2800 | Excel | 1 | 12-17-2014 10:41 AM |
Return entire program to default
|
blockie | Word | 2 | 04-13-2013 07:18 PM |
| Return Entire Row | ibrahimaa | Excel | 3 | 01-10-2012 05:44 AM |