Hi, I'm new to this..
I currently have a csv with addresses. And one of the values is "New York, NY" - however the convert to avro processor seems to be having issues with the comma even though it's enclosed with quotation marks.
I'm running into an issue with commas. If a value is "New York, NY" the converter seems to have issues.
I'm using the default CSV quote character and my csv has city, state enclosed in dbl quotes but if I remove the comma it works fine.
Any suggestions for this case?
Hi Harry, Check out the post here and see if this doesn't help solve your problem. https://community.hortonworks.com/questions/17996/nifi-applying-an-avro-schema-in-convertcsvtoavro.h...
If you have specified double quotes as the CSV quote character, then the comma delimiter inside the quotes will be ignored. It's unclear from your description what you were expecting vs. what is happening.
I am using double quotes as my quote character. And it doesn't ignore the comma inside there quotations. If I manually remove the comma the file is converted just fine.