I am testing a chat bot with inputs, and one of the rows reads, for example
entityInput, Just in case, where is the nearest doctor's office
The input is sending only "Just in case". I have tried Just in case\, where is the nearest doctor's office
Did you read the CSV specification (RFC 4180) or the Wikipedia page? It says exactly that you don't escape ,
but rather wrap whole text into ""
so
entityInput, "Just in case, where is the nearest doctor's office"
should work as long as implementation is compliant.
Good Answer. I’d add this tip: Use a library for reading/writing such data, like Apache Commons CSV.
Thanks, I knew I'd done this before. Note you also have to set "Allow Quoted Data" to True on the CSV Data Set Config node.