View Single Post
 
Old 11-21-2011, 08:29 AM
sesproul sesproul is offline Windows 7 64bit Office 2007
Novice
 
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