Merge Blank Fields Use {IF NOT BLANK} in Prim

DocumentID: 651207
Revision Date: 29-Feb-96 8:29:05 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Solutions: In most situations, if a field has some blank records, you put {Field}1?~ in the primary file for the fields which are in question. If all of the fields are in question the "?" will not work if certain fields do not have information in them. Here is a format to get around this. This is an example of a primary file with 5 fields where each field may not have information in it: {IF NOT BLANK}1~{FIELD}1~ {END IF}{IF NOT BLANK}2~ {IF NOT BLANK}1~[HRt] {END IF}{FIELD}2~{END IF} {IF NOT BLANK}3~{IF NOT BLANK}2~[Hrt] {END IF}{FIELD}3~{END IF} {IF NOT BLANK}4~{IF NOT BLANK}3~[Hrt] {END IF}{FIELD}4~{END IF} {IF NOT BLANK}5~{IF NOT BLANK}4~[Hrt] {END IF}{FIELD}5~ {END IF} Extra spaces need to be before the {END IF} command. This is so that there will be space between the fields if there is text in them. Also, all formatting commands encountered in the primary file get transferred to the new file when you merge. If you are attempting to prevent a blank line, the [HRt] code will need to be between the {IF NOT BLANK} and the {END IF} commands.

Answer:

Details:

Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.