Top Navigational Bar

Convert - Commas Not Converting To {END FIELD
DocumentID: 617558
Revision Date: 29-Feb-96 1:37:40 PM

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

Problem

Symptoms: When a customer converts an ASCII delimited file from dBASE III Plus, some of the commas are not converting to the {END FIELD} code. If the unconverted file is retrieved using Text In/Out (Ctrl-F5), the commas are in the file but CONVERT.EXE doesn't recognize them. Solutions: The use of CONVERT.EXE with ASCII delimited dBASE files is limited. If none of the fields have commas within the field, then using a comma delimiter will work correctly. It will also work if a field has a comma followed by a space (i.e., "Smith, John"). This will convert correctly. The problem is when there is a field that has a comma without a space following it and there are no quotes around the field (i.e., 12,000). If the delimiter is a comma, the field will be broken, and if the delimiter is quote comma (",) there will not be an {END FIELD} code. dBASE does not put quotes around numeric fields. The numeric fields with commas will have to be converted manually.

Another way to work around this problem is to have the customer save the file in dBASE as a DIF file. Then try using the Convert program to convert the file as a Spreadsheet DIF file. This has been successful for some customers. Note: ConvertPerfect will handle this situation correctly.

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.