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?
Please sign in to leave a comment.