Order an array

[unrealxqt]

Hi there,

At the university, I need to create a project in Python language and I'm stuck with a function that is needed to finish my work.
The task is:

There is a file called data, which contains the following lines (help: (id. itemname; description; price) ):
1. grillsütő; jó állapotú; 5000
4. gyerek bicikli; 14"-os; 10000
6. roller; piros; 2000
7. kenyérpirító; fekete; 2000
11. szék; barna; 2000

There is another file called update which contains these lines:
7. 1500
4. 9000
5. túracipő; új; 20000
6. visszavon
11. 1800
12. láncfűrész; Stihl; 27000

My task is to create a file called newdata, using these two. The newdata file should look like this:
I need to update the prices of items where it has a price after the id in update file,
add a new item where it has a whole new item line,
delete the given item where it says "visszavon"

so the final newdata should look like this:
1. grillsütő; jó állapotú; 5000
4. gyerek bicikli; 14"-os; 9000
5. túracipő; új; 20000
7. kenyérpirító; fekete; 1500
11. szék; barna; 1800
12. láncfűrész; Stihl; 27000

The problem is that I cannot order this list by the items id number. Actually I can, but it looks like it is ordered alphabetically, because 11 is less than 4 on my list.

My newdata looks like this:
1. grillsütő; jó állapotú; 5000
11. szék; barna; 1800
12. láncfűrész; Stihl; 27000
4. gyerek bicikli; 14"-os; 9000
5. túracipő; új; 20000
7. kenyérpirító; fekete; 1500

This is my current code:

import re

#1. grillsütő; jó állapotú; 5000
#4. gyerek bicikli; 14"-os; 10000
#6. roller; piros; 2000
#7. kenyérpirító; fekete; 2000
#11. szék; barna; 2000

#Read Input
dataFile = open("data.txt","r");
updateFile = open("update.txt","r");
outputFile = open("newdata.txt","w");

data = []

for line in dataFile:
	txt=line
	re1='(\\d+)'			# Integer Number 1
	re2='(\\.)'				# Any Single Character 1
	re3='(\\s+)'			# White Space 1
	re4='(\\w+[^;]*)'	    # Word 1
	re5='(;)'				# Any Single Character 2
	re6='(\\s+)'			# White Space 2
	re7='(\\w+[^;]*)'	    # Word 2
	re8='(;)'				# Any Single Character 3
	re9='(\\s+)'			# White Space 3
	re10='(\\d+)'			# Integer Number 2

	rg = re.compile(re1+re2+re3+re4+re5+re6+re7+re8+re9+re10,re.IGNORECASE|re.DOTALL)
	m = rg.search(txt)
	if m:
		targy_azonositoja = m.group(1)
		pont = m.group(2)
		elso_szunet = m.group(3)
		targy_neve = m.group(4)
		elso_pontosvesszo = m.group(5)
		masodik_szunet = m.group(6)
		targy_leirasa = m.group(7)
		masodik_pontosvesszo = m.group(8)
		harmadik_szunet = m.group(9)
		targy_ara = m.group(10)
		data.append(targy_azonositoja+pont+elso_szunet+targy_neve+elso_pontosvesszo+masodik_szunet+targy_leirasa+masodik_pontosvesszo+harmadik_szunet+targy_ara)

print(data)
print("\n\n")
#visszavonás		
for line in updateFile:
	txt = line
	regex_visszavon_1 = '(\\d+)'
	regex_visszavon_2 = '(\\.)'
	regex_visszavon_3 = '( )'
	regex_visszavon_4 = '(visszavon)'
	
	rg = re.compile(regex_visszavon_1+regex_visszavon_2+regex_visszavon_3+regex_visszavon_4, re.IGNORECASE|re.DOTALL)
	m = rg.search(txt)
	if m:
		targyat_visszavon_id = m.group(1)
		for adat in data:
			if (adat.startswith(targyat_visszavon_id+". ")):
				data.remove(adat)
print(data)
print("\n")

#ár módosítása
updateFile.seek(0)

for line in updateFile:
	txt = line
	regex_armodositas_1 = '(\\d+)'
	regex_armodositas_2 = '(\\.)'
	regex_armodositas_3 = '( )'
	regex_armodositas_4 = '(\\d+)'
	
	rg = re.compile(regex_armodositas_1+regex_armodositas_2+regex_armodositas_3+regex_armodositas_4, re.IGNORECASE|re.DOTALL)
	m = rg.search(txt)
	if m:
		armodositas_id = m.group(1)
		#print("Modositas: "+str(armodositas_id)+" -> "+str(m.group(4)))
		index = -1
		for adat in data:
			#print(adat)
			index+=1
			#print("Index: "+str(index))
			if (adat.startswith(armodositas_id+". ")):
				result = re.sub(';\\s+\\d{3,}', '; '+m.group(4), adat)
				#print(str(result))
				data[index] = result
	
	
print("\n")
print(data)


#uj tárgy felvétele
updateFile.seek(0)

for line in updateFile:
	txt=line
	re1='(\\d+)'			# Integer Number 1
	re2='(\\.)'				# Any Single Character 1
	re3='(\\s+)'			# White Space 1
	re4='(\\w+[^;]*)'	# Word 1
	re5='(;)'				# Any Single Character 2
	re6='(\\s+)'			# White Space 2
	re7='(\\w+[^;]*)'	# Word 2
	re8='(;)'				# Any Single Character 3
	re9='(\\s+)'			# White Space 3
	re10='(\\d+)'			# Integer Number 2

	rg = re.compile(re1+re2+re3+re4+re5+re6+re7+re8+re9+re10,re.IGNORECASE|re.DOTALL)
	m = rg.search(txt)
	if m:
		targy_azonositoja = m.group(1)
		pont = m.group(2)
		elso_szunet = m.group(3)
		targy_neve = m.group(4)
		elso_pontosvesszo = m.group(5)
		masodik_szunet = m.group(6)
		targy_leirasa = m.group(7)
		masodik_pontosvesszo = m.group(8)
		harmadik_szunet = m.group(9)
		targy_ara = m.group(10)
		data.append(targy_azonositoja+pont+elso_szunet+targy_neve+elso_pontosvesszo+masodik_szunet+targy_leirasa+masodik_pontosvesszo+harmadik_szunet+targy_ara)

print("\n\nEREDMÉNY\n\n")	
print(data)
print("\n\nVÉGE")


data.sort()

for line in data:
	print(line)
	outputFile.write(line+"\n")

dataFile.close();
updateFile.close();
outputFile.close();