Kafka connect csv

hello everyone , i’m using spooldir connector to connect csv and kafka on field of the csv contain comma inside it so connector sees it as a new field what i should do ?

Do you have an example of the payload? Is the comma inside a field with quotation marks?

This is one of the reasons that character separated file formats can be such a nuisance to handle :slight_smile:

1 Like

no the comma inside a field with Parentheses not quotes like this (omar , alqashlan)

That’s not valid CSV then - you’re going to need to pre-process the file to make it valid, or use a different ingest approach.

1 Like