Thursday, 11 May 2017

convert text column into JSON formt

We have a resource bundle/properties in the following format :

[tag1]
server1
server2
[tag2]
server3
server4
[tag3]
server5
server6
[No Software Installed]
server7
[tag2]
server8
[tag5]
server9
[tag1]
server10
server11
[tag3]
server12
server13
server14
server15
[tag6]
server16
server17

we need this to be converted into a JSON format such as this:

[
["tag1","server1,server2"],
["tag2","server3,server4"],
["tag3","server5,server6"],
["No Software Installed","server7"],
["tag2","server8"],
["tag5","server9"],
["tag1","server10,server11"],
["tag3","server12,server13,server14,server15"],
["tag6","server16,server17"]
]

Are there any existing tools to carry our such transformation ?



via JhnWorks

No comments:

Post a Comment