T
Tom Bean
I am trying to create a document containing up to 30 items in a bulleted
list based on the value of MERGEFIELDs corresponding to each item but am
having problems getting the merge to work correctly.
An example of the list in my current document is:
{ IF { MERGEFIELD Field1 } <> "" "§ Value of Field1 is { MERGEFIELD
Field1 }<Enter>
" }{ IF { MERGEFIELD Field2 } <> "" "§ Text for Field2<Enter>
" }{ IF { MERGEFIELD Field3 } <> "" "§ Text for Field3<Enter>
" }{ IF { MERGEFIELD Field4 } <> "" "§ Value of Field4 is { MERGEFIELD
Field4 }<Enter>
" }<Enter>
where <Enter> indicates where the 'Enter' key is pressed resulting in a
paragraph mark.
I want the document merged using the above example to look like:
§ Value of Field1 is Value1
§ Text for Field2
§ Value of Field4 is Value4
where the data source has "Value1", "Y", "" and "Value4" in Field1, Field2,
Field3 and Field4 columns.
The first problem I encountered was with Bullets showing a blank line if the
condition was not True, hence the square symbol at the beginning of the
text.
After replacing Bullets with the square symbol, everything appeared to work
when all the merge fields had non-empty values. When the value for Field3
was empty, as in the above example, neither the line for Field3 or Field4
were displayed. From various data patterns I tried, the output stopped when
the first empty column was encountered.
Thinking the empty columns might be the problem, I tried putting "N" for the
value of the fields I didn't want displayed and changed the IF statement to
IF { MERGEFIELD Field1 } <> "N". Once again this resulted in unexpected
behavior, all the lines were displayed regardless of whether on not they
contained an "N" and after the first "N" was encountered, the values for
subsequent fields was not shown.
Obviously, I'm doing something wrong.
Can someone please tell me how to do this correctly?
Thanks,
Tom
list based on the value of MERGEFIELDs corresponding to each item but am
having problems getting the merge to work correctly.
An example of the list in my current document is:
{ IF { MERGEFIELD Field1 } <> "" "§ Value of Field1 is { MERGEFIELD
Field1 }<Enter>
" }{ IF { MERGEFIELD Field2 } <> "" "§ Text for Field2<Enter>
" }{ IF { MERGEFIELD Field3 } <> "" "§ Text for Field3<Enter>
" }{ IF { MERGEFIELD Field4 } <> "" "§ Value of Field4 is { MERGEFIELD
Field4 }<Enter>
" }<Enter>
where <Enter> indicates where the 'Enter' key is pressed resulting in a
paragraph mark.
I want the document merged using the above example to look like:
§ Value of Field1 is Value1
§ Text for Field2
§ Value of Field4 is Value4
where the data source has "Value1", "Y", "" and "Value4" in Field1, Field2,
Field3 and Field4 columns.
The first problem I encountered was with Bullets showing a blank line if the
condition was not True, hence the square symbol at the beginning of the
text.
After replacing Bullets with the square symbol, everything appeared to work
when all the merge fields had non-empty values. When the value for Field3
was empty, as in the above example, neither the line for Field3 or Field4
were displayed. From various data patterns I tried, the output stopped when
the first empty column was encountered.
Thinking the empty columns might be the problem, I tried putting "N" for the
value of the fields I didn't want displayed and changed the IF statement to
IF { MERGEFIELD Field1 } <> "N". Once again this resulted in unexpected
behavior, all the lines were displayed regardless of whether on not they
contained an "N" and after the first "N" was encountered, the values for
subsequent fields was not shown.
Obviously, I'm doing something wrong.
Can someone please tell me how to do this correctly?
Thanks,
Tom
