Examples of com.knowgate.misc.CSVParser.parseFile()

com.knowgate.misc.CSVParser.parseFile()

Parse a delimited text file

Parsed values are stored at an internal array in this CSVParser.
File is readed using the character set specifid at constructor @param oFile CSV File @param sFileDescriptor A list of column names separated by ',' ';' '|' '`' or '\t'.Column names may be quoted. Lines are delimiter by '\n' characters
Example 1) tx_mail,tx_name,tx_surname
Example 2) "tx_name","tx_surname","tx_salutation"
@throws IOException @throws FileNotFoundException @throws ArrayIndexOutOfBoundsException Delimited values for a file is greaterthan columns specified at descriptor. @throws RuntimeException If delimiter is not one of { ',' ';' '|' '`' or '\t' } @throws NullPointerException if oFile or sFileDescriptor are null @throws IllegalArgumentException if sFileDescriptor is "" @throws UnsupportedEncodingException @since 3.0


    iColCount = aCols.length;


    CSVParser oParser = new CSVParser (sCharSet);


    oParser.parseFile (sFilePath, sColList.replace(',',sColDelim.charAt(0)));


    final int iRowCount = oParser.getLineCount();


    oResults = new Vector (iRowCount, 1);

    TableLoader oTblLdr = new TableLoader(sTableName);
    oTblLdr.prepare(getConnection(),oColList);
    String[] aColumns = oTblLdr.columnNames();


    CSVParser oCsvPrsr = new CSVParser(sEncoding);
    oCsvPrsr.parseFile(sFilePath, Gadgets.join(aColumns,"\t"));
    final int nLines = oCsvPrsr.getLineCount();
    final int nCols = oCsvPrsr.getColumnCount();


    getConnection().setAutoCommit(false);

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.