[NIFI-8761] Enable not setting a value for Escape Character in CSVReader controller service

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Extensions
• Assignee: Timea Barna
• Reporter: Peter Gyori
• Created: 06/Jul/21 13:27
• Updated: 24/Aug/21 14:36
• Resolved: 24/Aug/21 14:36

Description

Currently Escape Character is a mandatory property in the CSVReader controller service. Whenever a custom CSV format is specified in the reader, it needs to be provided. If it is not set, it defaults to '\'. It would be useful to allow the users not to set this value in which case no character would be considered an escape character. CSVFormat class allows passing null value as the escape char (to the constructor) and some built-in formats (RFC 4180, Microsoft Excel, Tab-delimited, Informix Unload Escape Disabled) actually use this setting.
Also modify the CSVRecordSetWriter, so the record could be written in alignment with the reader.

Issue Links

• links to: GitHub Pull Request #5249