Question

Source: https://stackoverflow.com/questions/58859344/how-to-convert-csv-to-nested-json-in-java

I have a csv file of following format:

A_aa,A_ab,A_ac,A_ad,B_BB_ba,B_BB_BBB_bb

1,2,3,4,5,6

And I want to convert it into the following nested JSON:

{

'A':{

'aa' : '1',

'ab' : '2',

'ac' : '4',

'ad' : '5',

}

'B':{

'BB':{

'ba' : '5',

'BBB':{

'bb' : '6'

}

}

}

}

Answer

The CSV file’s first row contains field headers (the underline is used to represent the hierarchical relationship. Detail data begins from the second row. Your need is to transform the CSV to JSON. The difficulty lies in dynamic parsing because it involves grouping, recursion, loop, conditional judgment and string concatenation. The code will be really lengthy if you try to achieve your task using Java.

It is easy to achieve this using SPL, the open-source Java package. Five lines of code are enough:

SPL offers JDBC driver to be invoked by Java. Just store the above SPL script as recurse.splx and invoke it in Java as you call a stored procedure:

…

Class.forName("com.esproc.jdbc.InternalDriver");

con= DriverManager.getConnection("jdbc:esproc:local://");

st = con.prepareCall("call recurse()");
st.execute();

…

View SPL source code.