在Java中将csv行转换为JSON对象 [英] Converting csv row to JSON object in Java

问题描述

我有一个csv文件类似这个

I've a csv file something similar to this

"name.firstName","name.givenName","name.DisplayName","phone.type","phone.value"
"john","maverick","John Maverick","mobile","123-123-123"
"jim","lasher","Jim Lasher","mobile","123-123-123"

我想将第2行和第3行转换为JSON对象。使用第一行作为Header。因此结果将是

I want to convert the 2nd and 3rd row into JSON objects.Using the first row as Header. So the result will be

[
{  
"name": {
    "firstName": "john",
    "givenName": "maverick",
    "DisplayName": "John Maverick"
},
"phone": {
    "type": "mobile",
    "value": "123-123-123"
}
},
{
"name": {
    "firstName": "john",
    "givenName": "maverick",
    "DisplayName": "John Maverick"
},
"phone": {
    "type": "mobile",
    "value": "123-123-123"
}
]

任何想法如何实现这一点？

Any idea how to achieve this?

推荐答案

图书馆可能会帮助你。 http://www.jonathanhfisher.co.uk/playpen/csv2json/index.htm

Here is a Java library that may help you. http://www.jonathanhfisher.co.uk/playpen/csv2json/index.htm

这里是一个JavaScript库，可能对您有用也可能不对您有用。 http://www.cparker15.com/code/utilities/csv-to- json /

Here is a JavaScript library that may or may not be useful to you. http://www.cparker15.com/code/utilities/csv-to-json/

最后，这是一个可能有用的过去答案。我喜欢OpenCSV解决方案。但是，而不是JAXB，你可以使用杰克逊。 将CSV文件转换为Java中的JSON对象

And finally, here is a past answer that may be useful. I like the OpenCSV solution. However, instead of JAXB, you could use Jackson. Converting an CSV file to a JSON object in Java

这篇关于在Java中将csv行转换为JSON对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！