Hi Peter,
Actually, after removing the 'MERGEFIELD', for use with an ASK field, all
those scenarios work for 'XX' as a string, but not as a
bookmark. Tested with:
{QUOTE{ASK PatientCode}"1"
{IF {PatientCode \*Upper} = XX @}"2"
{IF "{PatientCode \*Upper}" = XX @}"3"
{ IF {PatientCode \*Upper} = "XX" @}"4"
{IF "{PatientCode \*Upper}" = "XX" @}}
If you input 'XX' or 'xx' into the 'ASK PatientCode' field, you get
'1@2@3@4@' as the output. Anything else returns nothing, which
is as it should be. Mergefields work the same way.
If XX is a bookmark, as in:
{QUOTE{ASK PatientCode}{ASK XX}"1"
{IF {PatientCode \*Upper} = XX @}"2"
{IF "{PatientCode \*Upper}" = XX @}"3"
{ IF {PatientCode \*Upper} = "XX" @}"4"
{IF "{PatientCode \*Upper}" = "XX" @}}
and input 'XX' or 'xx' into the 'ASK PatientCode' field, you get '1@2@34'
as the output (ie only the first and second versions
work). Anything else returns nothing.
If you want to use 'XX' as a bookmark, that will work in the 3rd & 4th
cases too *if the 'XX' is in a field*, as in:
{QUOTE{ASK PatientCode}{ASK XX}"1"
{IF {PatientCode \*Upper} = {XX} @}"2"
{IF "{PatientCode \*Upper}" = {XX} @}"3"
{ IF {PatientCode \*Upper} = "{XX}" @}"4"
{IF "{PatientCode \*Upper}" = "{XX}" @}}
Now, if you input 'AA' or 'aa' into the 'ASK PatientCode' field, and 'AA'
(upper case only) in the 'ASK XX' field, or any other
matching characters, you get '1@2@3@4@' as the output but anything else
returns nothing.
Cheers
--
macropod
[MVP - Microsoft Word]
| As I've said before, there are occasions when you have to have at least
some
| of the quotes. They may be unusual, but it's good defensive programming
to
| use them, although of course, in the absence of a complete specification
of
| what fields do, even adding quotes isn't necessarily going to have the
| desired result in all situations. For example, in this case, try
inserting a
| bookmark called XX in the document (it can be a regular bookmark or
created
| using { SET XX something }, then evaluate
|
| { IF {MERGEFIELD PatientCode \*Upper } = XX @ }
|
| { IF "{MERGEFIELD PatientCode \*Upper }" = XX @ }
|
| { IF {MERGEFIELD PatientCode \*Upper } = "XX" @ }
|
| { IF "{MERGEFIELD PatientCode \*Upper }" = "XX" @ }
|
| I think only the last one works correctly where PatientCode is xx or XX.
|
| That's why I usually advise use of quotes.
|
| Peter Jamieson
| | > Hi Doug,
| >
| > Since there's no spaces in the test condition or true/false results,
the
| > field works equally well with no quote characters:
| > {IF{MERGEFIELD PatientCode \*Upper} = XX @}
| >
| > Another potential issue is whether the 'PatientCode' field contains
| > exactly 'XX' - no more & no less. The OP said "As part of the
| > testing i have printed to screen Value X to confirm it contains the
data
| > for the condition to be met". That's only one 'X'. Or is
| > 'Value X' the name of a/the field?
| >
| > Cheers
| >
| > --
| > macropod
| > [MVP - Microsoft Word]
| >
| >
| > | > | Remove the quotation marks from "{ MERGEFIELD PatientCode \*Upper}"
| > |
| > | --
| > | Hope this helps.
| > |
| > | Please reply to the newsgroup unless you wish to avail yourself of
my
| > | services on a paid consulting basis.
| > |
| > | Doug Robbins - Word MVP
| > |
| > | | > | > On 8 Feb, 16:55, (e-mail address removed) wrote:
| > | >> On 8 Feb, 16:15, "Graham Mayor" <
[email protected]>
wrote:
| > | >>
| > | >>
| > | >>
| > | >>
| > | >>
| > | >> > And do test the result of {Mergefield PatientCode} without a
| > condition
| > | >> > to
| > | >> > ensure it reproduces exactly what you think it should
reproduce.
| > Try
| > | >> > also
| > | >>
| > | >> > { IF { MERGEFIELD PatientCode \*Upper} = "XX" "@" }
| > | >> > --
| > | >> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
| > | >> > Graham Mayor - Word MVP
| > | >>
| > | >> > My web sitewww.gmayor.com
| > | >> > Word MVP web sitehttp://word.mvps.org
| > | >> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
| > | >>
| > | >> > Peter Jamieson wrote:
| > | >> > > 1. Are all the {} the special field code braces that you can
| > insert
| > | >> > > using ctrl-F9?
| > | >> > > 2. Is the value definitely XX and not xx, xX etc?
| > | >> > > 3. Try adding double quotes around the { MERGEFIELD } field,
i.e.
| > | >>
| > | >> > > { IF "{ MERGEFIELD PatientCode }" = "XX" "@" "" }
| > | >>
| > | >> > > Peter Jamieson
| > | >> > >| > | >> > >> On 8 Feb, 15:33, (e-mail address removed) wrote:
| > | >> > >>> Hi - i am having a few problems with the if then else
| > conditional
| > | >> > >>> statement with word mail merge. The logic that i am
looking to
| > | >> > >>> implement is if Value X = XX then print @ else print
nothing.
| > The
| > | >> > >>> code is below. Now this seems very simple but for some
reason
| > | >> > >>> doesnt work and even when the condition is met it does not
| > print @.
| > | >> > >>> As part of the testing i have printed to screen Value X to
| > confirm
| > | >> > >>> it contains the data for the condition to be met but it
doesnt
| > | >> > >>> write the @. { IF { MERGEFIELD PatientCode } = "XX" "@"
"" }
| > | >>
| > | >> > >> So the issue i have is that although the condition seems to
have
| > | >> > >> been
| > | >> > >> met it does not execute the correct part of the conditional
| > | >> > >> statement. The data being used for the mail merge comes
from a
| > SQL
| > | >> > >> 2000 SP3a database.- Hide quoted text -
| > | >>
| > | >> > - Show quoted text -
| > | >>
| > | >> Hi - thanks for your suggestions - i cant try them at the moment
as
| > | >> production is down
. With regards word mail merge i dont have
any
| > | >> exeperience apart from the hour or so that i have spent looking
at
| > | >> this issue (although i have numerous years of development
| > experience -
| > | >> somewhat offset by the fact i am now a manager
).
| > | >>
| > | >> In one of the suggestions the code used \*Upper - i pressume that
| > | >> there must be numerous other switches e.g. \*Lower etc. Is there
a
| > FAQ
| > | >> that describes all these 'switches' - cant seem to find mention
of
| > | >> them Word Help.
| > | >>
| > | >> Thanks in advance,
| > | >>
| > | >> CM- Hide quoted text -
| > | >>
| > | >> - Show quoted text -
| > | >
| > | >
| > | > Hi - just tried the suggested fix and it still doesnt work - the
code
| > | > is below;
| > | >
| > | > { IF "{ MERGEFIELD PatientCode \*Upper}" = "XX" "@" }
| > | >
| > | > Any other suggestions - this is really frustrating because for all
| > | > intents and purposes it should work. I have tried using the same
| > | > logic with another merge field and it works fine - could there be
| > | > anything in particular with this field that might mean that the
| > | > condition is not being met?
| > | >
| > | > Thanks in advance,
| > | >
| > | > CM
| > | >
| > | >
| > | >
| > | >
| > |
| > |
| >
| >
|
|
