Top Navigational Bar

Merge - DOS Delimited Text File Without Endin
DocumentID: 654029
Revision Date: 29-Feb-96 8:29:28 PM

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

Problem

Solutions: If the delimiters in a DOS delimited text file do not include the last comma after the last quote mark in the record, every other record is skipped when merging. Besides skipping records, the last quote mark will remained in each of the merged records.

Users can set the merge file delimiters with the following keystrokes:
1.      Press Ctrl-F9
2.      Select option 1
3.      Enter the primary filename
4.      Press Ctrl-F5
5.      Press Ctrl-F5 and enter the name of the DOS Text delimited file
6.      Change the Begin Field Delimiter to a blank and the End delimiter to a comma. Some users prefer to enter a quote and comma (",) as the End delimiter. When doing so they avoid possible problems with a city, state zip situation. However, this may cause extra " to appear in the merged text. A search and replace can be run to eliminate the extras.
7.      Change the Begin Record Delimiter to a quote (") and the End delimiter to "[CR][LF]

Here is an example of a DOS delimited file that does not have the last comma after the quote at the end of the record:

"First name","Last name","Street Address","City, State Zip"[HRt]
"First name","Last name","Street Address","City, State Zip"[HRt]

Notice that there is not a comma at the end of the quote before the [HRt].


*This information is given strictly as a troubleshooting option.

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.