Hi All,
I am using Export SQL to Flat File Smart Service where for of the column we have large text value (A paragraph value with spaces) which is enclosed in "" automatically by the Smart service.
Other text values without spaces (E.g. Prakhar_Garg_09_10_2017) is coming perfect without any "" (Quotes).
Please let me know what I am missing here.
Thanks
Discussion posts and replies are publicly visible
Thanks for your reply.
I got the root cause of this behaviour. This is happening due to "escapeCsv" function used to get the column value and this function has its own properties that if text includes comma/""/new line then text will be enclosed in Quotes.
https://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringEscapeUtils.html#escapeCsv-java.lang.String-
I will be stripping comma/""/new line before saving the data into database and then when this Plugin will be used for creating file, it will not have any issue (Tested and working fine).