mattalex
08-28-2021, 06:47 PM
I have a text file (see example) which I want to process using EXCEL VBA and output the information into an excel table. Please see example input and output below.
Any help with this would be appreciated!
***********OUTPUT IN EXCEL:***********
"application":{"id":
2071141
"council_reference:
P21/1902
"date_scraped":
2021-08-06T02:11:05.000Z
"address":
5 Matthew Street Mccrae VIC 3938
"description":
Development of a double storey dwelling
etc., etc.
***********TEXT FILE INPUT:***********
[{"application":{"id":2071141,"council_reference":"P21/1902","date_scraped":"2021-08-06T02:11:05.000Z","address":"5 Matthew Street Mccrae VIC 3938","description":"Development of a double storey dwelling","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P21%2F1902\u0026f=%24P1.ETR.APP DET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-08-04","on_notice_from":null,"on_notice_to":null,"lat":-38.355574,"lng":144.938677,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},{"application":{"id":2068983,"council_reference":"P19/0542.01","date_scraped":"2021-08-05T02:09:51.000Z","address":"13 Poole Street Mccrae VIC 3938","description":"Development of dwelling alterations and additions and associated works in accordance with the endorsed plans","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P19%2F0542.01\u0026f=%24P1.ETR. APPDET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-07-21","on_notice_from":null,"on_notice_to":null,"lat":-38.354865,"lng":144.9361654,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},{"application":{"id":2053341,"council_reference":"P21/1769","date_scraped":"2021-07-26T12:27:57.000Z","address":"16 Parkes Street Mccrae VIC 3938","description":"Dwelling additions","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P21%2F1769\u0026f=%24P1.ETR.APP DET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-07-20","on_notice_from":null,"on_notice_to":null,"lat":-38.35321649999999,"lng":144.9386219,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},
Any help with this would be appreciated!
***********OUTPUT IN EXCEL:***********
"application":{"id":
2071141
"council_reference:
P21/1902
"date_scraped":
2021-08-06T02:11:05.000Z
"address":
5 Matthew Street Mccrae VIC 3938
"description":
Development of a double storey dwelling
etc., etc.
***********TEXT FILE INPUT:***********
[{"application":{"id":2071141,"council_reference":"P21/1902","date_scraped":"2021-08-06T02:11:05.000Z","address":"5 Matthew Street Mccrae VIC 3938","description":"Development of a double storey dwelling","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P21%2F1902\u0026f=%24P1.ETR.APP DET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-08-04","on_notice_from":null,"on_notice_to":null,"lat":-38.355574,"lng":144.938677,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},{"application":{"id":2068983,"council_reference":"P19/0542.01","date_scraped":"2021-08-05T02:09:51.000Z","address":"13 Poole Street Mccrae VIC 3938","description":"Development of dwelling alterations and additions and associated works in accordance with the endorsed plans","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P19%2F0542.01\u0026f=%24P1.ETR. APPDET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-07-21","on_notice_from":null,"on_notice_to":null,"lat":-38.354865,"lng":144.9361654,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},{"application":{"id":2053341,"council_reference":"P21/1769","date_scraped":"2021-07-26T12:27:57.000Z","address":"16 Parkes Street Mccrae VIC 3938","description":"Dwelling additions","info_url":"https://epeninsula.mornpen.vic.gov.au/P1PRPROD/P1/eTrack/eTrackApplicationDetails.aspx?ApplicationId=P21%2F1769\u0026f=%24P1.ETR.APP DET.VIW\u0026r=P1.WEBGUEST","comment_url":null,"date_received":"2021-07-20","on_notice_from":null,"on_notice_to":null,"lat":-38.35321649999999,"lng":144.9386219,"authority":{"full_name":"Mornington Peninsula Shire Council"}}},