Quotes in quoted strings

CloverDX Platform
1

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

2

Hi Eric,

Please double the quote character for escaping:

"Michael ""Mike"" O'Neil"
3

That worked!

Thank you Milan!

Eric