Announcement Announcement Module
Collapse
No announcement yet.
How to Ignore Double Quotes in incoming csv file Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Ignore Double Quotes in incoming csv file

    has anyone ran into this issue; We have input files the we ETL ,using Spring Batch 2.1.8, that have double quotes that surround certain values in the input stream. These quotes must be maintained for further downstream processing.

    Is there a way to tell the provided LineMapper to ignore these quotes when tokenizing the unput record or is a custom implementaion required ?
    ie.

    incoming record-> 190025^Port^2374^Conference ""Stat""^
    outgoing -> 190025^Port^2374^Conference ""Stat""^

    Currently the tolenizer produces :
    outgoing -> 190025^Port^2374^Conference "Stat"^

    thanks

  • #2
    By default the DelimitedLineTokenizer assumes " is a quote character. In this scenario, I think if you just change it to something else (say $) you should be fine.

    Comment


    • #3
      ok Great. thanks for the reply. Will give it a go.

      Comment

      Working...
      X