I have a text file that lists all the source file information included in a GIS MXD project. I'd like to search the file and reformat the results into a new table. I'm not a programmer - just sort of dinking around with this to see if I can get it to work.
I'd like to capture the information after each of the following and add them to a row or record in a new text file or excel file... For each MAPDOUMENT there are many of the the other three fields I want to capture.
" MAPDOCUMENT: "
"Data Source: "
"Dataset type: "
I've attached a dummy file to show the file structure. Again Each Mxd has many layers. I need the layer name, data source, and dataset type for each one. Any ideas? I am hoping for some sort of simple query or something i can do in note pad or Excel.
Goal would be a table with fields for the MapDocument, Layer, Data Source, and Dataset type.