[DataSpider Servista] When using CSV File Adapter, one double quote becomes two double quotes automatically
When the data that includes ["(double quote)] is output with CSV file adapter, one double quote becomes two double quotes automatically. What is the reason?
When there is a variable-length adapter, it is possible to output without escaping the double-quotation in the variable-length write process.
For variable-length write process, please refer to the links given in Reference Information.
The operation mentioned in your question will be the CSV adapter specifications. When write data includes ["] then the output will be [" "].
(Thus, it is called Escape where double-quotation is attached to the double-quotation)
The above-mentioned will be the specification in accordance with official specification(RFC). For RFC of CSV, please refer to "Reference Information".
Handling method
To display by excluding the double-quotation
For example, if you want to display the data ["aa] as [aa] then use the logic that replaces the strings such as replacing logic for each string, and it can be achieved by replacing double-quotation for the null character.
There are multiple logics for replacing the strings. Hence, for more details, please check the links given in Reference Information.
To display the double-quotation as such
When there is a variable-length adapter, it is possible to output without escaping the double-quotation in the variable-length write process.
For variable-length write process, please refer to the links given in Reference Information.