private static void setCsvDelimiterEscape(Csv csv, String fieldSeparator, String fieldDelimiter, String escapeCharacter) { if (fieldSeparator != null) { csv.setFieldSeparatorWrite(fieldSeparator); if (fieldSeparator.length() > 0) { char fs = fieldSeparator.charAt(0); csv.setFieldSeparatorRead(fs); } } if (fieldDelimiter != null) { char fd = fieldDelimiter.length() == 0 ? 0 : fieldDelimiter.charAt(0); csv.setFieldDelimiter(fd); } if (escapeCharacter != null) { char ec = escapeCharacter.length() == 0 ? 0 : escapeCharacter.charAt(0); csv.setEscapeCharacter(ec); } }
setEscapeCharacter(ch); } else if (isParam(key, "fieldDelimiter", "fieldDelim")) { setFieldDelimiter(ch); } else if (isParam(key, "fieldSeparator", "fieldSep")) { setFieldSeparatorRead(ch);
private void setCsvDelimiterEscape(Csv csv, String fieldSeparator, String fieldDelimiter, String escapeCharacter) { if (fieldSeparator != null) { csv.setFieldSeparatorWrite(fieldSeparator); if (fieldSeparator.length() > 0) { char fs = fieldSeparator.charAt(0); csv.setFieldSeparatorRead(fs); } } if (fieldDelimiter != null) { char fd = fieldDelimiter.length() == 0 ? 0 : fieldDelimiter.charAt(0); csv.setFieldDelimiter(fd); } if (escapeCharacter != null) { char ec = escapeCharacter.length() == 0 ? 0 : escapeCharacter.charAt(0); csv.setEscapeCharacter(ec); } }
private static void setCsvDelimiterEscape(Csv csv, String fieldSeparator, String fieldDelimiter, String escapeCharacter) { if (fieldSeparator != null) { csv.setFieldSeparatorWrite(fieldSeparator); if (fieldSeparator.length() > 0) { char fs = fieldSeparator.charAt(0); csv.setFieldSeparatorRead(fs); } } if (fieldDelimiter != null) { char fd = fieldDelimiter.length() == 0 ? 0 : fieldDelimiter.charAt(0); csv.setFieldDelimiter(fd); } if (escapeCharacter != null) { char ec = escapeCharacter.length() == 0 ? 0 : escapeCharacter.charAt(0); csv.setEscapeCharacter(ec); } }
private static void setCsvDelimiterEscape(Csv csv, String fieldSeparator, String fieldDelimiter, String escapeCharacter) { if (fieldSeparator != null) { csv.setFieldSeparatorWrite(fieldSeparator); if (fieldSeparator.length() > 0) { char fs = fieldSeparator.charAt(0); csv.setFieldSeparatorRead(fs); } } if (fieldDelimiter != null) { char fd = fieldDelimiter.length() == 0 ? 0 : fieldDelimiter.charAt(0); csv.setFieldDelimiter(fd); } if (escapeCharacter != null) { char ec = escapeCharacter.length() == 0 ? 0 : escapeCharacter.charAt(0); csv.setEscapeCharacter(ec); } }
/** * Configure a Csv object based on the settings * * * @param csv * @return */ public Csv configure(Csv csv) { //csv.setLineSeparator("\n"); if(fieldDelimiter != null) { csv.setFieldDelimiter(fieldDelimiter); } if(fieldSeparator != null) { csv.setFieldSeparatorRead(fieldSeparator); } if(escapeCharacter != null) { csv.setEscapeCharacter(escapeCharacter); } return csv; } }
csv.setFieldDelimiter('\t'); csv.setFieldSeparatorRead('\t'); ResultSet reader = csv.read(new BufferedReader(new InputStreamReader(fis)), null);
csv.setFieldDelimiter('\t'); csv.setFieldSeparatorRead('\t'); ResultSet reader = csv.read(new BufferedReader(new InputStreamReader(fis)), null);
csv.setFieldDelimiter('\t'); csv.setFieldSeparatorRead('\t'); ResultSet reader = csv.read(new BufferedReader(new InputStreamReader(fis)), null);
@Override public void exportTable(Connection connection, String tableReference, File fileName, ProgressVisitor progress) throws SQLException, IOException { if (FileUtil.isExtensionWellFormated(fileName, "tsv")) { final boolean isH2 = JDBCUtilities.isH2DataBase(connection.getMetaData()); TableLocation location = TableLocation.parse(tableReference, isH2); Statement st = null; try { st = connection.createStatement(); Csv csv = new Csv(); csv.setFieldDelimiter('\t'); csv.setFieldSeparatorWrite("\t"); csv.write(fileName.getPath(), st.executeQuery("SELECT * FROM " + location.toString()), null); } finally { if (st != null) { st.close(); } } } else { throw new SQLException("Only .tsv extension is supported"); } }
@Override public void exportTable(Connection connection, String tableReference, File fileName, ProgressVisitor progress) throws SQLException, IOException { if (FileUtil.isExtensionWellFormated(fileName, "tsv")) { final boolean isH2 = JDBCUtilities.isH2DataBase(connection.getMetaData()); TableLocation location = TableLocation.parse(tableReference, isH2); Statement st = null; try { st = connection.createStatement(); Csv csv = new Csv(); csv.setFieldDelimiter('\t'); csv.setFieldSeparatorWrite("\t"); csv.write(fileName.getPath(), st.executeQuery("SELECT * FROM " + location.toString()), null); } finally { if (st != null) { st.close(); } } } else { throw new SQLException("Only .tsv extension is supported"); } }
@Override public void exportTable(Connection connection, String tableReference, File fileName, ProgressVisitor progress) throws SQLException, IOException { if (FileUtil.isExtensionWellFormated(fileName, "tsv")) { final boolean isH2 = JDBCUtilities.isH2DataBase(connection.getMetaData()); TableLocation location = TableLocation.parse(tableReference, isH2); Statement st = null; try { st = connection.createStatement(); Csv csv = new Csv(); csv.setFieldDelimiter('\t'); csv.setFieldSeparatorWrite("\t"); csv.write(fileName.getPath(), st.executeQuery("SELECT * FROM " + location.toString()), null); } finally { if (st != null) { st.close(); } } } else { throw new SQLException("Only .tsv extension is supported"); } }
csv.setFieldDelimiter('\t'); csv.setFieldSeparatorRead('\t'); ResultSet reader = csv.read(new BufferedReader(new InputStreamReader(fis)), null);
setEscapeCharacter(ch); } else if (isParam(key, "fieldDelimiter", "fieldDelim")) { setFieldDelimiter(ch); } else if (isParam(key, "fieldSeparator", "fieldSep")) { setFieldSeparatorRead(ch);
setEscapeCharacter(ch); } else if (isParam(key, "fieldDelimiter", "fieldDelim")) { setFieldDelimiter(ch); } else if (isParam(key, "fieldSeparator", "fieldSep")) { setFieldSeparatorRead(ch);