Need simple example with quotedStrings

ericl

• March 28, 2013 00:00

• Answered

Follow

Hi,

I'm a beginner at using Clover. I'm currently using the code from DataParsing.java (provided in the examples/JavaExamples section) and it works perfectly except for the case where my data fields are surrounded by quotes.

My source file has this format: "John", "Smith", etc.

I tried to set the quotedStrings to true at the record level, hence something like this:

<Record fieldDelimiter="," recordDelimiter="\r\n" name="Person" recordSize="-1" type="delimited" skipFirstLine="false" quotedStrings="true">

but the resulting values after being parsed still end up with the double quotes (I end up with "John" with the double quotes from the call to record.getField(0).toString()).

After reading a bit on the forum I discovered that the quotedStrings attribute seems to apply only to the DataReader.

If that is the case, would someone have a simple example on how to use the DataReader in regards of the DataParsing.java example ?

Thank you very much!

Eric

• 

  slechtaj

  • March 29, 2013 13:09

  0

  Comment actions Permalink

  Hi Eric,
  
  A similar issue has been reported in earlier versions. What version do you use?
• 

  ericl

  • April 01, 2013 14:02

  0

  Comment actions Permalink

  I'm using version 3.3.1.
  
  Am I doing it correctly by using the quotedStrings attribute at the "Record" level in the fmt file ?
  
  Any alternative to make this work would be greatly appreciated!
  
  Thank you!
  
  Eric
• 

  slechtaj

  • April 02, 2013 13:59

  0

  Comment actions Permalink

  Hi Eric,
  
  DataParsing.java does not use any external FMT file. The metadata are created inside the code. Due to a logic in the code, it is not possible to set qutedStrings in the java file, since this would be ignored.
  However, you may sligthly modify the code. All you need to do is to replace parser
  

  Parser parser = TextParserFactory.getParser(metadata);

  
  with the following code:
  

   final TextParserConfiguration parserCfg = new TextParserConfiguration();
  	 	parserCfg.setMetadata(metadata);
  	 	parserCfg.setCharset("UTF8");
  	 	parserCfg.setVerbose(true);
  	 	parserCfg.setTreatMultipleDelimitersAsOne(false);
  	 	parserCfg.setQuotedStrings(metadata.isQuotedStrings());
  	 	parserCfg.setQuoteChar(metadata.getQuoteChar());
  	 	parserCfg.setSkipLeadingBlanks(false);
  	 	parserCfg.setSkipTrailingBlanks(false);
  	 	parserCfg.setTryToMatchLongerDelimiter(DataRecordUtils.containsPrefixDelimiters(parserCfg.getMetadata()));
  	 	parserCfg.setTrim(null);
  	 	Parser parser = TextParserFactory.getParser(parserCfg); 

  
  
  Besides this, you will also need to adjust the metadata accordingly to your data source.
  
  Please note that you should be working on component level (create your own graphs) instead of pareser level.
• 

  ericl

  • April 02, 2013 15:00

  0

  Comment actions Permalink

  Thank you very much Jan, that solved my problem!
  
  I will read more on processing the data at the component level, any simple example you could suggest (GraphSort.java maybe) ?
  
  Thanks again,
  
  Eric
• 

  slechtaj

  • April 03, 2013 14:01

  0

  Comment actions Permalink

  Hi Eric,
  
  Yes, this is correct, GraphSort.java is the file you may use. There is also another example (XMLGraph.java), which is used to run the graph from XML definition.

Please sign in to leave a comment.