Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2011, 08:29 AM
sesproul sesproul is offline regular Expressions Formatting for Search Windows 7 64bit regular Expressions Formatting for Search Office 2007
Novice
regular Expressions Formatting for Search
 
Join Date: Nov 2011
Posts: 1
sesproul is on a distinguished road
Default regular Expressions Formatting for Search

Hello,

I have a question about a Mail Merge where I have a comma delimited string being fed in to a Variable. it looks like this:



As Requested,For Review and Approval,For Review and Comment,For Your Information

I have been attempting to search in the string to compare to a specific String ie. "For Review and Comment", which may be in any location as the previous and following strings may or may not be present.

Normally I would then take the Merge field and in a IF comparison look for a match and then do something like the Following:

{ IF <Transmit> = "For Review and Comment" "(X)" "( )"}

(I am Checking boxes on a form)


But I can't identify substrings in the <Transmit> field. then I noticed that the formatting option looks a lot like regular expressions, but I am not sure, would it be possible to apply a formatting that identifies my string as the output of the Mail Merge, that would then be able to be compared?


Thanks.

Steve
Reply With Quote
  #2  
Old 11-30-2011, 05:02 AM
macropod's Avatar
macropod macropod is offline regular Expressions Formatting for Search Windows 7 64bit regular Expressions Formatting for Search Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Steve,

For the most part, that kind of string comparison is not possible with Word fields. I say 'the most part' because it is possible to test whether the field begins or ends with a particular string, or if the string is in a particular location.

Also, it's far from clear what your doing, since mailmerges and formfields generally don't work together.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
regular Expressions Formatting for Search regular expressions in footnotes loes Word 3 09-04-2019 07:52 AM
Regular Expressions davidlooney Excel Programming 1 08-20-2018 08:23 AM
regular Expressions Formatting for Search Regular expressions for text with complex formatting Kreol2013 Word VBA 1 04-12-2013 07:33 PM
regular expressions for empty lines eNGiNe Word 1 01-21-2013 06:38 AM
regular Expressions Formatting for Search Regular Expressions: [!0-9] does not work??? tinfanide Excel Programming 4 05-30-2012 04:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:39 AM.


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