java - 如何将波浪号分隔的 csv 文件转换为 java 中的 xml

Question

1RW~800~4~22~1~48:2~true
1RW~800~16~39~1~48:2~true
1RW~800~640~330~1~48:2~true
1RW~800~40~124~1~48:2~true

这是我的 csv 文件文本，我想阅读它并将每个值放入由 ~ 分隔的行中到不同的 xml 元素中。我将循环遍历这个并形成 4 个不同的 xml

Answer 1

您可以使用OpenCSV (简短教程 here )读取 CSV 文件和 write it to a XML .

这是使用上述技术实现此目的的一种方法

// create the CSVReader
CSVReader reader = new CSVReader(new FileReader("yourfile.csv"), '~');

// create the DocumentBuilder which will create our xml documents
DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = docFactory.newDocumentBuilder();

// create the transoformer which will make the xml ready for storing
TransformerFactory transformerFactory = TransformerFactory.newInstance();
Transformer transformer = transformerFactory.newTransformer();

// loop through the 4 rows
for (int i = 0; i < 4; i++) {

    // read one row from the csv
    String [] line = reader.readNext()

    // create an xml document
    Document doc = docBuilder.newDocument();
    Element rootElement = doc.createElement("data-"+i);
    doc.appendChild(rootElement);

    // iterate over the entries in the row
    for (String s : line) {
        Element element = doc.createElement("element");
        element.appendChild(doc.createTextNode(s));
        rootElement.appendChild(element);
    }

    // finally save it:
    DOMSource source = new DOMSource(doc);
    StreamResult result = new StreamResult(new File("file_"+i+".xml"));
    transformer.transform(source, result);

    System.out.println("File " + i + " saved!");
}