import re


# grabs the animal id, eartag and name of the animal from herdcompanion html all herd list view-source:https://www.herdcompanion.co.uk/WebForms/HerdList.aspx

f = open('hc.txt', 'r')

trim = re.findall('herd_identity=(.+?)&amp;animal_identity=(.+?)&amp;ear_tag=(.+?)" style="color:#0D45B7;font-size:12px;text-decoration:underline;">(.+?)</a>', f.read(), re.DOTALL)

herd_identity= re.search('herd_identity=(.+?)&amp', f.read())

#print(herd_identity.group())

print(trim)

output_file = open('nc-animals.txt', 'w')

for cow in trim:


    #insert into hc_cow_details (herd_number, hc_cow_id, eartag, cow_number) values ()
    output_file.write("insert into hc_cow_details (herd_number, hc_cow_id, eartag, cow_number) values (" + cow[0] + "," + cow[1] + ",'" + cow[2] + "'," + cow[3] + ");\n")

output_file.close()