Quotes in quoted strings

ericl

• September 12, 2013 00:00

• Answered

Follow

Hi,

I'm currently just using the CloverETL java data parser (no graph) to parse some data files. The version we are using is 3.3.1.

One problem that we are facing is handling the quotes within a quoted string (ex: "Michael "Mike" O'Neil") where the quote character is " (double quote) and the quotedString attribute is set to true. This throw a

java.lang.RuntimeException: Parsing error: Bad quote format

.

I know that the problem was already reported here:

http://forum.cloveretl.com/viewtopic.php?f=4&t=528&p=1602&hilit=double+quote+in+quoted+string#p1602

But I was wondering if it has been fixed (ex: by using an escape character like the '\' and hence have something like "Michael \"Mike\" O'Neil").

Is there a plan to use an escape character for quotes within quotes in future releases ? It seems to be something that could happen quite often.

Thanks,
Eric

• 

  mkrivanek

  • September 24, 2013 14:57

  0

  Comment actions Permalink

  Hi Eric,
  
  Please double the quote character for escaping:
  

  "Michael ""Mike"" O'Neil"

• 

  ericl

  • September 30, 2013 17:42

  0

  Comment actions Permalink

  That worked!
  
  Thank you Milan!
  
  Eric

Please sign in to leave a comment.