Example usage for org.apache.commons.csv CSVRecord get

Introduction

In this page you can find the example usage for org.apache.commons.csv CSVRecord get.

Prototype

public String get(final String name)

Source Link

Document

Returns a value by name.

Usage

From source file:com.ibm.watson.catalyst.jumpqa.template.TextTemplateRecordReader.java

@Override
public PatternTemplate readRecord(final CSVRecord aRecord) {
    final String templateId = aRecord.get("Template ID");
    final Size matchSize = Size.valueOf(aRecord.get("Match Size").toUpperCase());
    final Size answerSize = Size.valueOf(aRecord.get("Answer Size").toUpperCase());
    final TextTemplateQuestioner questioner = new TextTemplateQuestioner(aRecord.get("Question"));
    final EntryPatterns matcher = new EntryPatterns(aRecord.get("Search 1"));
    // final String words1 = aRecord.get("Words 1");
    final SequentialReplacer sr = new SequentialReplacer(new File(aRecord.get("Words 3")));
    final Clean clean = StringCleaner.getClean(aRecord.get("Clean"));
    return new PatternTemplate(templateId, answerSize, matchSize, questioner, sr, clean, matcher);
}

From source file:br.edimarmanica.trinity.check.CheckNrPages.java

private int nrPagesExtracted() {
    Set<String> pages = new HashSet<>();
    File dir = new File(Paths.PATH_TRINITY + site.getPath() + "/offset");

    if (!dir.exists()) {
        return 0;
    }//w  w w .  j  av a  2s  . c  om

    for (File offset : dir.listFiles()) {

        try (Reader in = new FileReader(offset)) {
            try (CSVParser parser = new CSVParser(in, CSVFormat.EXCEL)) {
                for (CSVRecord record : parser) {
                    pages.add(record.get(0));
                }
            }
        } catch (FileNotFoundException ex) {
            Logger.getLogger(CheckNrPages.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
            Logger.getLogger(CheckNrPages.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    return pages.size();
}

From source file:br.edimarmanica.weir2.check.CheckDistanceExpectedMapping.java

private String getMasterRule(Site site, Attribute attribute) {
    try (Reader in = new FileReader(Paths.PATH_INTRASITE + "/" + site.getPath() + "/result.csv")) {
        try (CSVParser parser = new CSVParser(in, CSVFormat.EXCEL.withHeader())) {

            for (CSVRecord record : parser) {
                if (record.get("ATTRIBUTE").equals(attribute.getAttributeID())) {
                    if (record.get("RULE").equals("Attribute not found")) {
                        return null;
                    }//from www.jav a2s .  co  m
                    return record.get("RULE");
                }
            }
        }
    } catch (FileNotFoundException ex) {
        Logger.getLogger(CheckDistanceExpectedMapping.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        Logger.getLogger(CheckDistanceExpectedMapping.class.getName()).log(Level.SEVERE, null, ex);
    }

    return null;
}

From source file:net.decix.jatlasx.csv.CsvReader.java

public List<String> getColumn(String rowIdentifier) {

    CSVParser parser = null;/*  ww  w.  j  av a2 s. c  o m*/
    List<String> column = new ArrayList<String>();

    try {
        parser = new CSVParser(new FileReader(fileName), csvFileFormat);

        if (parser != null) {
            for (CSVRecord record : parser) {
                column.add(record.get(rowIdentifier).toString());
            }
        }

        parser.close();
    } catch (IOException e) {
        String errorMsg = "Could not read File:" + fileName;
        System.err.println(e.getClass().getName() + ":" + errorMsg + " (" + this.getClass().getName() + ")");
    }
    return column;
}

From source file:com.siemens.sw360.portal.users.UserCSV.java

public UserCSV(CSVRecord record) {
    givenname = record.get(0);
    lastname = record.get(1);//www  .j  a  v  a  2  s.co  m
    email = record.get(2);
    department = record.get(3);
    group = record.get(4);
    gid = record.get(5);
    isMale = Boolean.parseBoolean(record.get(6));
    hash = record.get(7);
    if (record.size() > 8) {
        wantsMailNotification = Boolean.parseBoolean((record.get(8)));
    }
}

From source file:moacscoper.Parser.java

public void addServers() throws IOException {
    List<CSVRecord> vms = parse("vm.dat");
    int serverNumber = 1;
    int performance;
    double reliability;
    double cost;//from w  ww  .  ja v a2  s  .  com
    for (CSVRecord r : vms) {
        performance = Integer.parseInt(r.get(0));
        reliability = Double.parseDouble(r.get(1));
        cost = Double.parseDouble(r.get(2));
        this.sim.servers.add(new Server(serverNumber + "", performance, reliability, cost));
        serverNumber++;
    }
}

From source file:cinematicketsim.DateTimeClassParser.java

public ArrayList<DateTime> loadData(String filename) {

    ArrayList<DateTime> dateTimeData = new ArrayList<DateTime>();

    try {//from  w  w w.  j  av a 2  s .c  om
        File f = new File(filename);
        filename = f.getCanonicalPath();

    } catch (Exception e) {
        e.printStackTrace();
    }

    FileResource file = new FileResource(filename);

    CSVParser parser = file.getCSVParser();

    for (CSVRecord record : parser) {

        String movieId = record.get("id");

        String showDate = record.get("date");

        String showTime = record.get("time");

        DateTime movieInfo = new DateTime(movieId, showDate, showTime);

        dateTimeData.add(movieInfo);

    }

    return dateTimeData;
}

From source file:indexer.PDFDocument.java

PDFDocument(CSVRecord record) {
    record.toMap().forEach(this::addMetadata);
    path = record.get("file");
    name = record.get("title");
}

From source file:moacscoper.Parser.java

public int addComponents() throws IOException {
    List<CSVRecord> components = parse("component.dat");
    int componentNumber = 0;
    int performance;
    double reliability;
    for (CSVRecord r : components) {
        performance = Integer.parseInt(r.get(0));
        reliability = Double.parseDouble(r.get(1));
        this.sim.components.add(new SoftwareComponent(componentNumber + 1, "c" + (componentNumber + 1),
                performance, reliability));
        componentNumber++;//from   w  ww .jav  a2s. c  om
    }
    return componentNumber; // return total number of components
}

From source file:debop4k.core.utils.CsvExTest.java

@Test
@SneakyThrows({ IOException.class })
public void readPM10() {
    InputStream input = Resources.getClassPathResourceStream("csv/pm10_station_all.csv");
    try {//from w  w  w . java 2 s. c o m
        assertThat(input).isNotNull();
        List<CSVRecord> records = Csvx.toCSVRecordList(input);
        for (CSVRecord record : records) {
            Integer stationId = asInt(record.get(1));
            DateTime endTime = asDateTime(record.get(2), "yyyy.MM.dd.HH:mm");
            DateTime startTime = asDateTime(record.get(3), "yyyy.MM.dd.HH:mm");
            String stationName = record.get(4);

            log.debug("stationId={}, endTime={}, startTime={}, stationName={}", stationId, endTime, startTime,
                    stationName);
        }
    } finally {
        input.close();
    }
}