![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
blockie | Word | 2 | 04-13-2013 07:18 PM |
Return Entire Row | ibrahimaa | Excel | 3 | 01-10-2012 05:44 AM |