Iterator<String> it = csvRecord.iterator(); if (!result.isEmpty()) { String next = it.next();
public GrblLookups(String prefix) { String filename = prefix + "_" + Localization.loadedLocale() + ".csv"; URL u = GrblLookups.class.getResource(pathFor(filename)); if (u == null) { filename = prefix + "_en_US.csv"; } try { try (BufferedReader reader = new BufferedReader( new InputStreamReader( GrblLookups.class.getResourceAsStream(pathFor(filename))))) { Iterable<CSVRecord> records = CSVFormat.RFC4180.withFirstRecordAsHeader().parse(reader); for (CSVRecord record : records) { List<String> list = Lists.newArrayList(record.iterator()); lookups.put(record.get(0), list.toArray(new String[0])); } } } catch (IOException ex) { System.out.println("Unable to load GRBL resources."); ex.printStackTrace(); } }
private static List<String> recordToList(CSVRecord record) { return Iter.toList(record.iterator()) ; } }
protected String[] getLine(CSVRecord record) throws IOException { Iterator<String> recordIterator = record.iterator(); int recordSize = record.size(); String[] values = new String[recordSize]; for (int i = 0; i < recordSize; i++) { if (recordIterator.hasNext()) { values[i] = (String)recordIterator.next(); } else { throw new IOException("Record size doesn't match the real size"); } } return values; }
import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord; List<String> results = new ArrayList<String>(); try (Reader rdr = new FileReader(pathToFile); CSVParser parser = CSVFormat.DEFAULT.parse(rdr);) { Iterator<CSVRecord> records = parser.iterator(); while (records.hasNext()) { CSVRecord row = records.next(); Iterator<String> values = row.iterator(); while(values.hasNext()) { results.add(values.next()); } } } catch(IOException e) { // log the error here }
private List<List<String>> parseFile(byte[] csvFileData) throws Exception { List<List<String>> data; Reader targetReader = null; CSVParser csvParser = null; try { CSVFormat csvFormat = CSVFormat.DEFAULT; targetReader = new InputStreamReader(new ByteArrayInputStream(csvFileData)); csvParser = new CSVParser(new BufferedReader(targetReader),csvFormat); List<CSVRecord> records = csvParser.getRecords(); data = new ArrayList<List<String>>(); for (CSVRecord csvRecord : records) { Iterator<String> iterator = csvRecord.iterator(); List<String> row = new ArrayList<String>(); while (iterator.hasNext()) { String column = iterator.next(); row.add(column); } data.add(row); } } catch (Exception e) { throw e; } finally { if(targetReader != null) targetReader.close(); if(csvParser != null) csvParser.close(); } return data; }
List<String> lineValues = Lists.newArrayList(); CSVRecord record = csvRecords.get(i); for (Iterator<String> iterator = record.iterator(); iterator.hasNext();) { lineValues.add(iterator.next());
String categoryName = null; List<List<String>> categoryData = new ArrayList<>(); while (iterator.hasNext()) { CSVRecord current = iterator.next(); if (current.size() == 1) { //start of next category processCategory(categoryName, categoryData); categoryName = current.get(0); categoryData.clear(); iterator.next(); //skip header } else { //category data List<String> rowData = new ArrayList<>(current.size()); CollectionUtils.addAll(rowData, current.iterator()); //uses Apache Commons Collections, but you can use whatever categoryData.add(rowData); } } processCategory(categoryName, categoryData); //last category of file
List<String> lineValues = Lists.newArrayList(); CSVRecord record = csvRecords.get(i); for (Iterator<String> iterator = record.iterator(); iterator.hasNext();) { lineValues.add(iterator.next());
Set<String> hmKeys = hm.keySet(); Iterator<String> hmKeysIT = hmKeys.iterator(); Iterator<String> it = record.iterator(); int i = 0; int normalFields = hmKeys.size()-1; for (CSVRecord record : records) { List<String> values = new ArrayList<>(); record.iterator().forEachRemaining(values::add); LinkedHashMap<String, Object> row = new LinkedHashMap<String, Object>(); row.put("field", values);
protected Value[] readRow() { CSVRecord record = iterator.next(); List<ValueType> valueTypes = getValueTypes(); Value[] values = new Value[valueTypes.size()]; int index = 0; for (String value : newArrayList(record.iterator())) { if (doubleQuote.equals(value)) { value = StringUtils.EMPTY; } else if (value != null && value.length() == 0) { value = null; } ValueType type = valueTypes.get(index); type = type != null ? type : STRING; switch (type) { case BINARY: values[index] = binary(BASE64.decode(value)); break; case STRING: values[index] = string(value); break; } index++; } fill(values, valueTypes, index); return values; }
@Override protected CatoDataObject nextDataObject() throws Exception { final List<String> data; if (csvVersion == CsvStaticDataReader.CSV_V2) { if (!this.iteratorV2.hasNext()) { return null; } data = IteratorUtils.toList(iteratorV2.next().iterator()); } else { String[] csvRow = this.csvreaderV1.readNext(); data = csvRow != null ? Arrays.asList(csvRow) : Lists.mutable.<String>empty(); } if (data == null || data.size() == 0 || (data.size() == 1 && data.get(0).isEmpty())) { return null; } else if (data.size() != this.fields.size()) { throw new IllegalArgumentException("This row does not have the right # of columns: expecting " + this.fields.size() + " columns, but the row was: " + Lists.mutable.with(data)); } CatoDataObject dataObject = this.createDataObject(); for (int i = 0; i < data.size(); i++) { dataObject.setValue(this.fields.get(i), data.get(i)); } // needed to preserve the order of rows in the difference calculation dataObject.setValue(ROW_NUMBER_FIELD, rowNumber++); return dataObject; }
@Override protected CatoDataObject nextDataObject() throws Exception { final List<String> data; if (csvVersion == CsvStaticDataReader.CSV_V2) { if (!this.iteratorV2.hasNext()) { return null; } data = IteratorUtils.toList(iteratorV2.next().iterator()); } else { String[] csvRow = this.csvreaderV1.readNext(); data = csvRow != null ? Arrays.asList(csvRow) : Lists.mutable.<String>empty(); } if (data == null || data.size() == 0 || (data.size() == 1 && data.get(0).isEmpty())) { return null; } else if (data.size() != this.fields.size()) { throw new IllegalArgumentException("This row does not have the right # of columns: expecting " + this.fields.size() + " columns, but the row was: " + Lists.mutable.with(data)); } CatoDataObject dataObject = this.createDataObject(); for (int i = 0; i < data.size(); i++) { dataObject.setValue(this.fields.get(i), data.get(i)); } // needed to preserve the order of rows in the difference calculation dataObject.setValue(ROW_NUMBER_FIELD, rowNumber++); return dataObject; }
Iterator<String> iterator = csvRecord.iterator(); while (iterator.hasNext()) { columnNames.add(iterator.next());
if (it.hasNext()) { CSVRecord record = (CSVRecord)it.next(); Iterator<String> recordIterator = record.iterator(); int recordSize = record.size(); header = new String[recordSize];
for (CSVRecord record : CSVParser.parse(obj, format).getRecords()) { List<String> it = new ArrayList<String>(); for (Iterator<String> x = record.iterator(); x.hasNext(); ) { it.add(x.next());
for (CSVRecord record : CSVParser.parse(obj, format).getRecords()) { List<String> it = new ArrayList<String>(); for (Iterator<String> x = record.iterator(); x.hasNext(); ) { it.add(x.next());
/** * Putting this init here so that we can discover the file fields before running the actual rec */ public void init() { if (!this.initialized) { try { MutableList<String> fields; if (csvVersion == CsvStaticDataReader.CSV_V2) { CSVFormat csvFormat = CsvStaticDataReader.getCsvFormat(delim, nullToken); this.csvreaderV2 = new CSVParser(reader, csvFormat); this.iteratorV2 = csvreaderV2.iterator(); fields = ListAdapter.adapt(IteratorUtils.toList(iteratorV2.next().iterator())); } else { this.csvreaderV1 = new au.com.bytecode.opencsv.CSVReader(this.reader, this.delim); fields = ArrayAdapter.adapt(this.csvreaderV1.readNext()); } this.fields = fields.collect(this.convertDbObjectName); } catch (Exception e) { throw new DeployerRuntimeException(e); } this.initialized = true; } }
/** * Putting this init here so that we can discover the file fields before running the actual rec */ public void init() { if (!this.initialized) { try { MutableList<String> fields; if (csvVersion == CsvStaticDataReader.CSV_V2) { CSVFormat csvFormat = CsvStaticDataReader.getCsvFormat(delim, nullToken); this.csvreaderV2 = new CSVParser(reader, csvFormat); this.iteratorV2 = csvreaderV2.iterator(); fields = ListAdapter.adapt(IteratorUtils.toList(iteratorV2.next().iterator())); } else { this.csvreaderV1 = new au.com.bytecode.opencsv.CSVReader(this.reader, this.delim); fields = ArrayAdapter.adapt(this.csvreaderV1.readNext()); } this.fields = fields.collect(this.convertDbObjectName); } catch (Exception e) { throw new DeployerRuntimeException(e); } this.initialized = true; } }