|
|
|
The OPTION control statement is used to alter the characters used to represent commas and periods in support of European conventions for representation of numerical data. If you want European support, specify comma as a period, and period as a comma. In this instance the variable in a CSV file is delimited by the semi-colon (;) character instead of the comma, and the decimal point is represented by the comma. For CA Earl users, the default setting 'EURO=.$' is changed by specifying the decimal point as a comma or swapping the pound symbol for the dollar sign. Below is an example of a CSV file created under these circumstances from either the Report Writer for this product or the CA Earl Report Writer.
"HCSV";"0000";"JARS";"C.0";"19980903";"160642";"CSVTST01";"CAI";"JARS";5;0000;"K2D1";" ";"DATA "COST CENTER RESOURCE";"SUB ID";"DEBIT";"CREDIT";"TOTAL CHARGE" "ACCOUNTING DEPT.";"RERUNS";,00;48,24;-48,24 "ACCOUNTING DEPT.";"PROGRAMMING TIME";431,00;,00;431,00 "ACCOUNTING DEPT.";"DATA ENTRY";116,00;,00;116,00 "ACCOUNTING DEPT.";"DATA CONTROL";57,00;,00;57,00 "ACCOUNTING DEPT.";"OFF-LINE CHARGES";120,00;,00;120,00 "ACCOUNTING DEPT.";"SUPPLIES";36,50;,00;36,50 "ACCOUNTING DEPT.";"TELCOM COSTS";120,00;,00;120,00 "ACCOUNTING DEPT.";"SYSTEMS SUPPORT";18,00;,00;18,00 " ","PRODUCTION" .00;,00;7,95 " ","PRODUCTION" .00;,00;2,99 "ADMINISTRATION";"PRODUCTION";,00;,00;,21 "SYSTEMS SUPPORT";"PRODUCTION";,00;,00;6,97 "PRODUCTION DEPT.";"PRODUCTION";,00;,00;,31
Note: The periods that appear within character fields were not replaced with commas. The swapping of commas for decimal points only occurs for numerical data.
| Copyright © 2012 CA. All rights reserved. |
|