Examples of com.Ostermiller.util.CSVParser

com.Ostermiller.util.CSVParser
miller.org/utils/CSVLexer.html">ostermiller.org. CSV is a file format used as a portable representation of a database. Each line is one entry or record and the fields in a record are separated by commas. Commas may be preceded or followed by arbitrary space and/or tab characters which are ignored.
If field includes a comma or a new line, the whole field must be surrounded with double quotes. When the field is in quotes, any quote literals must be escaped by \" Backslash literals must be escaped by \\. Otherwise a backslash an the character following it will be treated as the following character, ie."\n" is equivelent to "n". Other escape sequences may be set using the setEscapes() method. Text that comes after quotes that have been closed but come before the next comma will be ignored.
Empty fields are returned as as String of length zero: "". The following line has three empty fields and three non-empty fields in it. There is an empty field on each end, and one in the middle. One token is returned as a space.
```
,second,, ,fifth,
```
Blank lines are always ignored. Other lines will be ignored if they start with a comment character as set by the setCommentStart() method.
An example of how CVSLexer might be used:
```
 CSVParser shredder = new CSVParser(System.in); shredder.setCommentStart("#;!"); shredder.setEscapes("nrtf", "\n\r\t\f"); String t; while ((t = shredder.nextValue()) != null) { System.out.println("" + shredder.lastLineNumber() + " " + t); } 
```
Some applications do not output CSV according to the generally accepted standards and this parse may not be able to handle it. One such application is the Microsoft Excel spreadsheet. A separate class must be use to read Excel CSV. @see com.Ostermiller.util.ExcelCSVParser


    private XMLEventReader r;


    Digester(Reader reader, String extension) throws HttpException {
      if (extension.equals("csv")) {
        shredder = new CSVParser(reader);
        shredder.setCommentStart("#");
        shredder.setEscapes("nrtf", "\n\r\t\f");


      } else if (extension.equals("xml")) {
        XMLInputFactory factory = XMLInputFactory.newInstance();

View Full Code Here

    }
    try {
      if (isExcel) {
        shredder = new ExcelCSVParser(new StraightStreamReader(in));
      } else {
        CSVParser standardParser = new CSVParser(new StraightStreamReader(in));
        standardParser.setCommentStart("#!");
        standardParser.setEscapes("nrtf", "\n\r\t\f");
        shredder = standardParser;
      }
      shredder.changeDelimiter(delimiter);
    } catch (Exception e) {
      return null;

View Full Code Here


public class OstermillerParser implements Parser {
  private com.Ostermiller.util.CSVParser parser;
  
  public OstermillerParser(InputStream is , char separator) {
    parser = new CSVParser(is, separator);
  }

View Full Code Here

      return importEntity( ';');
    }
    public Object[] importEntity(char separator) {
        List ents = new ArrayList();
        try {
            CSVParser parser = new CSVParser(new FileInputStream(_csvfile), separator);
            String[] line = parser.getLine();
            Object ent;
            while (line != null) {
                ent = _cst.getObjectFromLine(line);
                if (ent != null) {
                    ents.add(ent);
                } else {
                    System.out.println("The csv file " + _csvfile.getAbsolutePath() + " does not contain proper data for " + _cst.getClass().getName());
                }
                line = parser.getLine();
            }
        } catch (BadDelimiterException e) {
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            System.out.println("The csv file " + _csvfile.getAbsolutePath() + " does not exist.");

View Full Code Here

TOP

Related Classes of com.Ostermiller.util.CSVParser

fr.jayasoft.commons.io.csv.OstermillerParser

net.sf.chellow.ui.GeneralImport$Digester

nu.lazy8.ledger.port.CsvImportPane

org.jayasoft.woj.server.servlet.ee.util.CSVImport

java.io.InputStream

java.io.File

java.io.FileInputStream

java.io.IOException

java.util.Vector

java.io.StringReader

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.