Loading csv file data in Elasticsearch with explicite double quote in the beginning and inside of some fields

Hello,
I'm new to Elastic search
I have to load a csv file into Elasticsearch - csv processor looks fine for the initial purpose
Some of the fields have the following non-regular structure:

  1. Explicit Double quotes in the beginning of the field- because several values comma separated inside the field like this:
    "2017-03-30T06:00:00Z,2017-03-10T22:00:00Z,2017-03-04T10:00:00Z,2017-03-03T14:00:00Z"
  2. Explicite double quotes in the middle of the field like that:
    5/16" Ring Terminal, 3 ft. 8 GA Black Ground Cable, 6 ft. Split Loom Tubing, Depth: 6.5" (165mm) (top) 11.2" (285mm), .....
    I tried to handle these cases but did not found any good solution to load all the data into the related index.
    How workaround these special cases with double quote in the beginning and in the middle of the initial CSV file ?
    Any ideas ?
    Best regards,

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.