Word mergefield wildcard not correctly matching

Posted by aZn137 on Super User See other posts from Super User or by aZn137
Published on 2010-05-06T17:06:20Z Indexed on 2010/05/06 17:08 UTC
Read the original article Hit count: 397

Hello,

Below is my mergefield code:

{ IF { MERGEFIELD Subs_State } = "GA" "blah blah" "{ IF { MERGEFIELD CEOrgStates } = "GA" "blah blah" ""} "}

I'm pulling records from a MS Access db. My goal is to check whether a record has Subs_State field matching "GA", or the CEOrgStates has the word "GA" (some records have stuff like "|FL|CA|GA|CT|KY|" (no quotes)).

When I merged the docs, Word doesnt seem to be able to match with the wildcards: If I use and compare "*GA" (fields ending with GA), it works; however, the double wildcards "*GA*" dont seem to work at all.

Here are the things I’ve tried:

  • Have data in lowercase, then compare with lowercase
  • Have data in lowercase, convert to and then compare with uppercase
  • Do the opposite of the above 2 with uppercase data
  • Use “*GA*” and “*ga*” (no pipe)
  • Use different delimiters

Nothing seems to work with the double wildcard matching. What am I doing wrong?

Thanks!

© Super User or respective owner

Word mergefield wildcard not correctly matching

Posted by aZn137 on Stack Overflow See other posts from Stack Overflow or by aZn137
Published on 2010-05-06T17:04:27Z Indexed on 2010/05/06 17:08 UTC
Read the original article Hit count: 397

Filed under:
|
|

Hello,

Below is my mergefield code:

{ IF { MERGEFIELD Subs_State } = "GA" "blah blah" "{ IF { MERGEFIELD CEOrgStates } = "GA" "blah blah" ""} "}

I'm pulling records from a MS Access db. My goal is to check whether a record has Subs_State field matching "GA", or the CEOrgStates has the word "GA" (some records have stuff like "|FL|CA|GA|CT|KY|" (no quotes)).

When I merged the docs, Word doesnt seem to be able to match with the wildcards: If I use and compare "*GA" (fields ending with GA), it works; however, the double wildcards "*GA*" dont seem to work at all.

Here are the things I’ve tried:

  • Have data in lowercase, then compare with lowercase
  • Have data in lowercase, convert to and then compare with uppercase
  • Do the opposite of the above 2 with uppercase data
  • Use “*GA*” and “*ga*” (no pipe)
  • Use different delimiters

Nothing seems to work with the double wildcard matching. What am I doing wrong?

Thanks!

© Stack Overflow or respective owner

Related posts about microsoft-word-2007

Related posts about mail-merge