pip7441622
New Member
- Joined
- Jan 26, 2005
- Messages
- 1
I am trying to create an Excel spreadsheet out of a txt file containing the following text:
[Document]
apc_ep_divest_land.apc_divest_land_a_num_sufx=CO0092015-97
apc_ep_divest_land.apc_divest_land_c_doc_type=CON - Contract & amendments, Init. summary
apc_ep_divest_land.title=DIVESTITURE
apc_ep_divest_land.apc_w_date=09/01/2004
apc_ep_divest_land.apc_divest_land_e_pg_count=68
apc_ep_divest_land.r_object_id=0900ff6881afd03e
PATH=H:\ImgExt\SEC New Land Documents\files\0900ff6881afd03e.tif
[Document]
apc_ep_divest_land.apc_divest_land_a_num_sufx=CO0100006-80
apc_ep_divest_land.apc_divest_land_c_doc_type=CON - Contract & amendments, Init. summary
apc_ep_divest_land.title=DIVESTITURE
apc_ep_divest_land.apc_w_date=09/01/2004
apc_ep_divest_land.apc_divest_land_e_pg_count=189
apc_ep_divest_land.r_object_id=0900ff6881afd041
PATH=H:\ImgExt\SEC New Land Documents\files\0900ff6881afd041.tif
This pattern is followed for many more records in the text file, with a record beginning with [Document] and ending with the PATH line. I need to make the "apc..." the column headings, with anything following the = to be in its own cell. Basically I need to extract the data after the =, with each record ( [Document] to the end of the PATH) being a single row. There are thousands of records, so doing this manually would not be desired. Any help at all would be appreciated. Thank You.
[Document]
apc_ep_divest_land.apc_divest_land_a_num_sufx=CO0092015-97
apc_ep_divest_land.apc_divest_land_c_doc_type=CON - Contract & amendments, Init. summary
apc_ep_divest_land.title=DIVESTITURE
apc_ep_divest_land.apc_w_date=09/01/2004
apc_ep_divest_land.apc_divest_land_e_pg_count=68
apc_ep_divest_land.r_object_id=0900ff6881afd03e
PATH=H:\ImgExt\SEC New Land Documents\files\0900ff6881afd03e.tif
[Document]
apc_ep_divest_land.apc_divest_land_a_num_sufx=CO0100006-80
apc_ep_divest_land.apc_divest_land_c_doc_type=CON - Contract & amendments, Init. summary
apc_ep_divest_land.title=DIVESTITURE
apc_ep_divest_land.apc_w_date=09/01/2004
apc_ep_divest_land.apc_divest_land_e_pg_count=189
apc_ep_divest_land.r_object_id=0900ff6881afd041
PATH=H:\ImgExt\SEC New Land Documents\files\0900ff6881afd041.tif
This pattern is followed for many more records in the text file, with a record beginning with [Document] and ending with the PATH line. I need to make the "apc..." the column headings, with anything following the = to be in its own cell. Basically I need to extract the data after the =, with each record ( [Document] to the end of the PATH) being a single row. There are thousands of records, so doing this manually would not be desired. Any help at all would be appreciated. Thank You.