Possible to select multiple quote characters during file upload configuration?

2 followers
0
Avatar

Hello,

I am getting a dropped record for a record that contains both " and '. My quote character is set to " right now, so I'm wondering if there is a way to add ' as a quote character.

Reason: IllegalStateException: Un-terminated quoted field at end of CSV line

Here is my record, note the presence of both " and ':

systemID|2016|12|000000008352916|GREATER ASSN OF "ST. GEOR|523|Essential|0002864204|SB-Palatine|2001183000000001865|GREATER ASSN OF 'ST GEOR|6RH|PALATINE 205|system|029||||0|2.661032|ACTUAL/ACTUAL|12/16/2002||0.267|0|0.267|16.935|0.036|0|-16.668|-4.501|-12.167|120.16|0|0|322.673333333333|0|9.3

There are many other records with " in them, and I believe others only have one " in a field as this record does. Any suggestions on how I can get this record to load?

Thanks,

Dominic

Bardele, Dominic Answered

2 comments

  • Avatar
    Alan Mark

    Hi Dominic,

    The use of quotes in this data is not as a "Quote Character" per se.  

    Try blanking out the quote character entirely and see if that helps.

    If it does not, you'll need to sanitize the incoming data by adding an escape character before the quote within the data itself, so the characters can be properly detected and handled.

    0
  • Avatar
    Bardele, Dominic

    Thanks, Alan! That did the trick and solved another error that the quotes were causing.

    0
Please sign in to leave a comment.