Child pages
  • EI Text Qualifiers for CSV files
Skip to end of metadata
Go to start of metadata

Text Qualifiers for CSV files 

Purpose

To show the limitations of using text qualifiers in resulting csv files in APD

Overview

Generally when using CSV files, outputted data can include commas and semi-colons as standard. This is not standard in analysis processing.

Use of text qualifiers in APD

At design stage in analysis processing, the user decides the type of result that is to be outputted. Where a csv file is the result, the presumption that text qualifiers are used is not permitted. If the output is created with comma separators and the result text includes a comma in the data, where standard use of csv files would cater for this by encasing the text with double-quotation marks, within APD the comma within the text is determined to be a column separator and this renders the output useless in many cases. The data is returned as expected but as the double-quotation text qualifiers are not included.

For example, the text string contains company name data that includes commas as part of the data. The commas are incorrectly interpreted as field separators rather than string data. There is no option in APD to enable text qualifiers when generating the CSV file.

Normally, when a flat file is used as a data source, the header line is expected to be in a particular format for the APD to recongnize and process it further. Keeping this in mind, APD is designed such that when a flat file is used as target in APD, the header line contains this special format so that it can be used as source in other APDs.

Keywords

file format,  quote,

Related Content

Related KBAs

1611495  How to change the delimiter for CSV export from WAD template

Related Notes

605208    RSCRM - Restrictions
605213    RSCRM: Performance
646699    Restrictions during the use of BW queries
751577    APD-FAQ: Data source query

  • No labels