Text to row & Column

  • 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\"}",

  • Dear experts

    Please ignore earlier post...

    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

    1. I have to break to new row if a string of text comes ["{\"

    2. After that the text to new column on the string of text \",\"

    3. The data has to be arranged under common headings

    cinotype_namecase_noreg_yearreg_nopetparty_nameresparty_namefil_yearfil_no


    Sample file attached


    Please help


    Jay