Possible to select multiple quote characters during file upload configuration?

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

Alan

April 12, 2017 20:02

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.

Bardele, Dominic

April 12, 2017 20:21

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

Possible to select multiple quote characters during file upload configuration?

Comments

Didn't find what you were looking for?