Converting Paradox File With Commas As Text I

DocumentID: 650543
Revision Date: 29-Feb-96 8:29:00 PM

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

Problem

Solutions: I was working with a customer that was using the convert program to convert a database file from Paradox to WP51. The problem she was running into was that there was a comma on the end of a field as part of the field text, as well as the "comma" that designates the field end. When it was converted, WP was treating the text comma as a field delimiter and putting in an extra {END FIELD} code which threw off the field numbers. I found out that this problem could be avoided by putting in {34} and a comma as the field delimiter so the text comma would be ignored. This works if the field ends in a double quote followed by a comma. It does not work if there is no double quote there. The database conversion is free form so that the users can adapt it to their own situations.

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.