![]() |
|
#2
|
||||
|
||||
|
As discussed under the 'Test Whether a Mergefield Contains a Given String' topic in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html), you would have to know the position of the '/' character. A '*/*' test is not possible. If the '/' can appear in numerous positions, you'd need to construct a compound test against each of those positions. For example:
{QUOTE{SET Data MERGEFIELD MyField}{IF{={IF{REF Data}= "?/*" 1 0}+{IF{REF Data}}= "??/*" 1 0}+{IF{REF Data}}= "???/*" 1 0}+{IF{REF Data}}= "????/*" 1 0}+{IF{REF Data}}= "?????/*" 1 0}> 0 "/ Found" "/ Not Found"}} Even then, Word can't parse the field to split out the sort_name.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| if/then/else, mergefields |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
Create a unique list of values that match a criteria, sorted in order of another criteria
|
BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.
|
phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
| Outlook, 5 day appointments and communicator presence | dowalker | Outlook | 0 | 10-28-2011 12:23 PM |
Conditional color fill based on presence of data
|
avanderh | Excel | 11 | 07-28-2011 09:10 AM |