Skip to content

Instantly share code, notes, and snippets.

@iHaagcom
Created November 25, 2017 17:11
Show Gist options
  • Save iHaagcom/0010e4974e2e956fefbaed0f7a7318a7 to your computer and use it in GitHub Desktop.
Save iHaagcom/0010e4974e2e956fefbaed0f7a7318a7 to your computer and use it in GitHub Desktop.
import re
import csv
#Define the search term:
fileAssetPatt = r'''fileAssetId":"([^"]*)''' #'(?<=\"fileAssetId\":\")[a-fA-F0-9-]+?(?=\")'
filenamePatt = r'''filename":"([^"]*)''' #'(?<=\"filename\":\").+?(?=\")'
identifyPatt = r'''id":([^,]*)''' #'(?<=\"id\":)[a-fA-F0-9-]+?(?=\,)'
namePatt = r'''"name":"([^"]*)''' #'(?<=\"name\":\").+?(?=\")'
#Create an empty list:
data = []
#then
for line in open(r'DocumentationNode.txt'):
if line !='': #<-- To make sure the whole file is read
fileAssetId = re.findall(fileAssetPatt, line)
filename = re.findall(filenamePatt, line)
identify = re.findall(identifyPatt, line)
name = re.findall(namePatt, line)
data.append(str(fileAssetId + filename + identify + name))
with open('file.csv', 'wt') as f:
writer = csv.writer(f, lineterminator='\n')
writer.writerow(fileAssetId)
writer.writerow(filename)
writer.writerow(identify)
writer.writerow(name)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment