remt | note-taking support tool for reMarkable tablet | Document Editor library

Excel vba

I am trying to remove certain unwanted text ( from JSON ) from a article (basically different news article) through Excel VBA

• [{"body2":""},{"body2":"
• [{"body2":""}
• "}
• ,{"body2":"
• \n
• \t
• "}]

E.g of article that needs to be edited

First example

[{"body2":"AA Engages the Community Despite Training and Operations\n\n"},{"body2":"We thank Mr tin Tan for his suggestions in the forum letter titled \"Give time off for SDE to volunteer\", dated 25 Jan 2014."},{"body2":"hhh serves the critical need of our way of life. As such, training and operations is the main priority. Nevertheless, the AA is actively involved in supporting our community. Our units organise community engagement projects regularly, such as visiting homes to help and encourage fellow people, and engaging students through the Schools Partnership Programme. These projects allow our people to participate in community service whilst fulfilling theirservice commitments. In 2013, our soldiers supported more than 50 homes and engaged more than 30 schools.\n"},{"body2":"G.Huang\nHead\nJoint Manpower Department"},{"body2":"\nSDE's reply was published as \"AA Engages the Community Despite Training and Operations\", The NEWs Times, 28 Jan 14"}]

Second example

[{"body2":""},{"body2":"Local universities offer SDE options for early entry"},{"body2":"AA would like to respond to issues raised from letters to the News Times on enabling full-time staff to enter universities earlier."},{"body2":"AA is mindful that Service requires staff to delay their personal pursuits, and will not make the duration of full-time service longer than necessary. The current two years of full-time is necessary to train our staff to the required level of proficiency so that they can be part of the standing force to meet operational needs."},{"body2":"subsequently, completes his full-time service."},{"body2":"AA grants disruptions to stuffs to allow them to commence their university studies at the same time as This ensures that they are no better off or worse off than their peers in the same cohort, who have also served NS."},{"body2":"In terms of entry to local universities, there are more options now."},{"body2":"In addition, the University of Technology and Design has a unique academic calendar that starts in May, ahead of other universities, and its eight-semester course can be completed in 3.5 year."},{"body2":"Tm\nDirector Manpower\ndepert\n"},{"body2":" "},{"body2":"SDE was published as \"Local varsities offer staff options for early entry: AA\", The News Times, 12 Jun 12"},{"body2":""}]

What i have done so far

For getting access to the remote host we need to login to the jumphost1 and then jumphost2. for that we are trying to create a tunnel like shown in the below python script.

My main purpose of this connection is to execute a script script and redirect the output at the same location where the script resides Script location is local machine from where the pyc file will create a tunnel and connect the remote machine.

Added info: both the jumphost are sshkeygen enables with passphrase. So it will ask password.