Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2019, 05:42 PM
scienceguy scienceguy is offline How to return the full string (entire word) when searching with wildcards in word vba Windows 10 How to return the full string (entire word) when searching with wildcards in word vba Office 2016
Advanced Beginner
How to return the full string (entire word) when searching with wildcards in word vba
 
Join Date: Feb 2019
Posts: 46
scienceguy is on a distinguished road
Default

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
Reply With Quote
Reply

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
How to return the full string (entire word) when searching with wildcards in word vba 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
How to return the full string (entire word) when searching with wildcards in word vba 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft