I will get one out put from this string @json1
{
"Status": "Success",
"Status Message": "Service Call Successful",
"Area":
[
{
"AreaCode":"A00009",
"AreaName":"BARSHI",
"FsCode":"TSM010",
"RegionCode":"R00001",
"RegionName":"MAHARASHTRA"
},
{
"AreaCode":"A00008",
"AreaName":"BANGALORE",
"FsCode":"TSM040",
"RegionCode":"R00901",
"RegionName":"KARNATAKA"
},
]
}
now i want to replace last charecter ',' between '}' and ']' symbol any solution would be greatly appreciated..
What I have tried:
i have tried
set @json1=reverse(STUFF(REVERSE(@json1),charindex(',',@json1),1,''))
but no use..
i want out put like this
{
"Status": "Success",
"Status Message": "Service Call Successful",
"Area":
[
{
"AreaCode":"A00009",
"AreaName":"BARSHI",
"FsCode":"TSM010",
"RegionCode":"R00001",
"RegionName":"MAHARASHTRA"
},
{
"AreaCode":"A00008",
"AreaName":"BANGALORE",
"FsCode":"TSM040",
"RegionCode":"R00901",
"RegionName":"KARNATAKA"
}
]
}