Dear experts
I have a unique problem. I searched for the solution in the existing posts and unable to find one.
I have to import a text file from an application into Excel sheet. In that I have to break to new row if a string of text comes ["{\"
After that the text to new column on the string of text \",\"
Please help
Jay
Sample text
["{\"cino\":\"TNED010000502012\",\"type_name\":\"OS\",\"case_no\":\"231701002372013\",\"reg_year\":2013,\"reg_no\":100237,\"petparty_name\":\"P.Kandasamy\",\"resparty_name\":\"P.Shanmugam\",\"fil_year\":\"0\",\"fil_no\":\"0\",\"establishment_name\":\"Principal District Court, Erode\",\"establishment_code\":\"TNED01\",\"state_code\":\"10\",\"district_code\":\"24\",\"state_name\":\"Tamil Nadu\",\"district_name\":\"Erode\",\"date_next_list\":\"2020-04-23\",\"date_of_decision\":null,\"date_last_list\":\"2020-03-19\",\"updated\":true,\"court_no_desg_name\":\"Principal District Judge\"}","{\"cino\":\"TNED010002822017\",\"type_name\":\"AS\",\"case_no\":\"230201000732017\",\"reg_year\":2017,\"reg_no\":100073,\"petparty_name\":\"Thirumayammal and 3 others\",\"resparty_name\":\"R.Thirumoorthy\",\"fil_year\":\"0\",\"fil_no\":\"0\",\"establishment_name\":\"Principal District Court, Erode\",\"establishment_code\":\"TNED01\",\"state_code\":\"10\",\"district_code\":\"24\",\"state_name\":\"Tamil Nadu\",\"district_name\":\"Erode\",\"date_next_list\":\"2018-04-24\",\"date_of_decision\":\"2018-04-24\",\"date_last_list\":\"2018-04-24\",\"updated\":true,\"court_no_desg_name\":\"Principal District Judge\"}",