Top Navigational Bar

Convert - Placing End Field Code At Comma Sep
DocumentID: 616383
Revision Date: 29-Feb-96 1:37:25 PM

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

Problem

Symptoms: When converting an ASCII delimited text file to a secondary merge file, if a numeric field with a comma separator is encountered, CONVERT.EXE will place an {END FIELD} code within the field. Solutions: Because of the way that the ASCII file was created, CONVERT.EXE cannot distinguish between a field delimiter and a thousands place marker in a number. In this customer's file, every field is separated by a single comma except numeric fields, which are enclosed in quotes. This is completely opposite of most ASCII delimited formats, which place quotes around every field except numeric fields. CONVERT.EXE does look at each comma to see if there is a space after it (e.g., "Smith, John"). If this case is encountered, the comma will not be converted to an {END FIELD} code.

In this customer's file, both cases of commas look the same to the conversion program. The only hope for the customer is if the program used to create the ASCII text will allow the customer to use another field delimiter besides a comma. ConvertPerfect handles this problem 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.