Blank field printing a 0 (zero)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 27 Apr 2005 20:53 GMT

My data source is an Excel spreadsheet and there are blank fields. How do I
tell it skip the field, not print a 0 (zero) move to next field?

Reply to this Message

Graham Mayor - 28 Apr 2005 06:55 GMT

Use a conditional field.
In theory {IF {Mergefield fieldname} <> 0 "{Mergefield Fieldname}"} should
do the trick.
If not, try
{IF {Mergefield fieldname} <> "" "{Mergefield Fieldname}"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> My data source is an Excel spreadsheet and there are blank fields.
> How do I tell it skip the field, not print a 0 (zero) move to next
> field?

Reply to this Message

Kim - 28 Apr 2005 18:30 GMT

A Great Big Thank You! It works!

> Use a conditional field.
> In theory {IF {Mergefield fieldname} <> 0 "{Mergefield Fieldname}"} should
[quoted text clipped - 5 lines]
> > How do I tell it skip the field, not print a 0 (zero) move to next
> > field?

Reply to this Message