Java CSVWriter.DEFAULT_SEPARATOR属性代码示例

@Override
public void initialise() throws IOException {
	// Create the parent dirs
	new File(csvFilename).getAbsoluteFile().getParentFile().mkdirs();

	writer = new CSVWriter(new FileWriter(csvFilename, false), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);

	// Print the header
	writer.writeNext(new String[] {
			"Type",
			"Subtype",
			"Source type",
			"Target type",
			"Lemma",
			"Lemma POS",
			"Alternatives...."
	});
}
 

public static char detectSeparator(String line) {
    StringBuffer buffer = new StringBuffer();
    Matcher matcher = UNIVERSAL_ALIAS_PATTERN.matcher(line);
    while (matcher.find()) {
        matcher.appendReplacement(buffer, "");
    }
    matcher.appendTail(buffer);

    String separateDetection = buffer.toString().replaceAll("[^,;|\\t]*", "");
    if (separateDetection == null)
        throw new ReportFormattingException("Error while detecting a separator");

    if (!separateDetection.isEmpty())
        return separateDetection.charAt(0);
    else
        return CSVWriter.DEFAULT_SEPARATOR;
}
 

/**
 * <p>Saves the table values to the given file.</p>
 * @param file
 * @throws IOException
 */
public void save(File file) throws IOException {
	CSVWriter writer = new CSVWriter(new FileWriter(file, true), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.NO_QUOTE_CHARACTER);
	int rowCount = model.getRowCount();
	int columnCount = model.getColumnCount();
	for(int i = 0; i < rowCount; i++) {
		String[] row = new String[columnCount];
		for(int a = 0; a < columnCount; a++) {
			row[a] = String.valueOf(model.getValueAt(i, a));
		}
		writer.writeNext(row);
	}
	writer.close();
}
 

private boolean runTask() {
	if (mAdapter == null || mAdapter.getCursor() == null)
		return false;
	// take cursor
	Cursor data = mAdapter.getCursor();
	// create object to write csv file
	try {
		CSVWriter csvWriter = new CSVWriter(new FileWriter(mFileName), CSVWriter.DEFAULT_SEPARATOR,
				CSVWriter.NO_QUOTE_CHARACTER);
		while (data.moveToNext()) {
			String[] record = new String[7];
			// compose a records
			record[0] = data.getString(data.getColumnIndex(QueryAllData.UserDate));
			if (!TextUtils.isEmpty(data.getString(data.getColumnIndex(QueryAllData.Payee)))) {
				record[1] = data.getString(data.getColumnIndex(QueryAllData.Payee));
			} else {
				record[1] = data.getString(data.getColumnIndex(QueryAllData.AccountName));
			}
			record[2] = Double.toString(data.getDouble(data.getColumnIndex(QueryAllData.Amount)));
			record[3] = data.getString(data.getColumnIndex(QueryAllData.Category));
			record[4] = data.getString(data.getColumnIndex(QueryAllData.Subcategory));
			record[5] = Integer.toString(data.getInt(data.getColumnIndex(QueryAllData.TransactionNumber)));
			record[6] = data.getString(data.getColumnIndex(QueryAllData.Notes));
			// writer record
			csvWriter.writeNext(record);
			// move to next row
			data.moveToNext();
		}
		csvWriter.close();
	} catch (Exception e) {
		Timber.e(e, "exporting to CSV");

		return false;
	}
	return true;
}
 

static int export(Database db, String tableName, Writer csv, boolean withHeader, boolean applyQuotesToAll, String nullText) throws IOException{
	Table table = db.getTable(tableName);
	String[] buffer = new String[table.getColumnCount()];
	CSVWriter writer = new CSVWriter(new BufferedWriter(csv), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.DEFAULT_QUOTE_CHARACTER);
	int rows = 0;
	try{
		if (withHeader) {
			int x = 0;
			for(Column col : table.getColumns()){
				buffer[x++] = col.getName();
			}
			writer.writeNext(buffer, applyQuotesToAll);
		}
           
		for(Row row : table){
			int i = 0;
			for (Object object : row.values()) {
				buffer[i++] = object == null ? nullText : object.toString();
			}
			writer.writeNext(buffer, applyQuotesToAll);
			rows++;
		}
	}finally{
		writer.close();
	}
	return rows;
}