[Solved] I AM TRYING TO SOLVE THE BELOW FUNCTION USING THE PYTHON REGEX MODULE BUT I AM NOT GETTING THE SAME RESULT AS REQUIRED. I WILL POST MY CODE…

admin

I AM TRYING TO SOLVE THE BELOW FUNCTION USING THE PYTHON REGEX…

BUT I AM NOT GETTING THE SAME RESULT AS REQUIRED. I WILL POST MY CODE BELOW THE FUNCTION SO IF SOMEONE CAN SHOW GIVING ME AN EXAMPLE WHERE I AM MAKING A MISTAKE. 
 

-Function search_by_postal_code_range(), this function takes the parameters starting_character and ending_number. The function will search the listings file for all properties that have postal code that falls between the starting character and the ending number or more, for example: If the starting_character = V and ending number = 5 then the postal codes that will fall within the given range should start with V. V1…, V3…, the postal code should end with a number from 5 to 9.
V1B 632 (Invalid)
V4X 3S5 (Valid)
V3B 6E6 (valid)
 
MY CODE AND OUT 
def search_by_postal_code_range(starting_character,ending_number)
open_file_in_reading_mode = open(“listings.txt”, “r”)
open_file_in_writing_mode = open(“report.txt”, “a”)
line = “”

header = “Listings that have a postal code that starts with” + str(starting_character) + “and ends with” + str(ending_number) + “or more:n”
open_file_in_writing_mode.write(header)
open_file_in_writing_mode.write(“*********n”)

for line in open_file_in_reading_mode:
regex_expression = “^” + str(starting_character) + “V{1}[0-9]{1}[A-Z ]{1}|”+ str(ending_number) +”[A-Z]|[0-9]{1}$”
result = re.search(regex_expression, line)
if result:
open_file_in_writing_mode.write(line)
I AM GETTING THIS RESULT 
R2507956,2242 Grant Street Vancouver BC V5L 2Z7,1699000,5,2,House,13
R2500627,305-1006 Burnaby Avenue Vancouver BC V6E 1T7,981000,2,2,Condo,34
R2512107,680 W 6th Avenue Vancouver BC V5Z 1A3,989000,2,2,Townhouse,1
R2512000,208-607 E 8th Avenue Vancouver BC V5T 1T2,574900,1,1,Condo,1
R2511923,2146 W 14th Avenue Vancouver BC V6K 2V7,2248000,3,3,House,31
R2511301,2638 Coquitlam Street Vancouver BC V5K 3A5,1890000,8,8,House,18
R2511809,307-2080 E Kent Avenue Vancouver BC V5P 4X2,449000,1,1,Condo,2
R2511747,1408-1775 Quebec Street Vancouver BC V5T 0E3,679900,1,1,Condo,5
R2511972,306-7180 Linden Avenue Burnaby BC V5E 3G6,448800,1,1,Condo,30
R2511059,7760 Berkley Street Burnaby BC V5E 2J7,1150000,2,1,House,20
R2511262,1106-9222 University Crescent Burnaby BC V5A 0A6,629800,2,2,Condo,4
R2510818,5190 Fulwell Street Burnaby BC V5G 1P2,1390000,7,4,House,15
R2510183,5712 Grant Street Burnaby BC V5B 2K4,1698000,3,4,House,18
R2512071,8154 Gilley Avenue Burnaby BC V5J 4Y5,2488000,9,9,House,1
R2510573,5059 Norfolk Street Burnaby BC V5G 1E9,1299000,4,4,House,7
R2512173,11226 236 Street Maple Ridge BC V2W 0C8 ,900000,4,4,House,35
R2512052,21560 Burnaby Court Maple Ridge BC V2X 8Z7,775000,3,2,House,43
R2508895,227-12258 224 Street Maple Ridge BC V2X 8Y7,474900,2,2,Condo,12
R2512451,102 Vancouver Court Coquitlam BC V3K 6E2,948000,4,2,House,20
R2512494,1803-1185 The High Street Coquitlam BC V3B 0A9,953000,3,2,Condo,10 
the expected result should be this 
R2507956,2242 Grant Street Vancouver BC V5L 2Z7,1699000,5,2,House,13
R2500627,305-1006 Burnaby Avenue Vancouver BC V6E 1T7,981000,2,2,Condo,34
R2511923,2146 W 14th Avenue Vancouver BC V6K 2V7,2248000,3,3,House,31
R2511301,2638 Coquitlam Street Vancouver BC V5K 3A5,1890000,8,8,House,18
R2511972,306-7180 Linden Avenue Burnaby BC V5E 3G6,448800,1,1,Condo,30
R2511059,7760 Berkley Street Burnaby BC V5E 2J7,1150000,2,1,House,20
R2511262,1106-9222 University Crescent Burnaby BC V5A 0A6,629800,2,2,Condo,4
R2512071,8154 Gilley Avenue Burnaby BC V5J 4Y5,2488000,9,9,House,1
R2510573,5059 Norfolk Street Burnaby BC V5G 1E9,1299000,4,4,House,7
R2512052,21560 Burnaby Court Maple Ridge BC V2X 8Z7,775000,3,2,House,43
R2508895,227-12258 224 Street Maple Ridge BC V2X 8Y7,474900,2,2,Condo,12
R2512494,1803-1185 The High Street Coquitlam BC V3B 0A9,953000,3,2,Condo,10 
HERE IS THE LISTINGS.TXT FILE FROM WHERE I NEED TO GET THE EXPECTED OUTPUT
R2507956,2242 Grant Street Vancouver BC V5L 2Z7,1699000,5,2,House,13
R2500627,305-1006 Burnaby Avenue Vancouver BC V6E 1T7,981000,2,2,Condo,34
R2512107,680 W 6th Avenue Vancouver BC V5Z 1A3,989000,2,2,Townhouse,1
R2512000,208-607 E 8th Avenue Vancouver BC V5T 1T2,574900,1,1,Condo,1
R2511923,2146 W 14th Avenue Vancouver BC V6K 2V7,2248000,3,3,House,31
R2511301,2638 Coquitlam Street Vancouver BC V5K 3A5,1890000,8,8,House,18
R2511809,307-2080 E Kent Avenue Vancouver BC V5P 4X2,449000,1,1,Condo,2
R2511747,1408-1775 Quebec Street Vancouver BC V5T 0E3,679900,1,1,Condo,5
R2511972,306-7180 Linden Avenue Burnaby BC V5E 3G6,448800,1,1,Condo,30
R2511059,7760 Berkley Street Burnaby BC V5E 2J7,1150000,2,1,House,20
R2511262,1106-9222 University Crescent Burnaby BC V5A 0A6,629800,2,2,Condo,4
R2510818,5190 Fulwell Street Burnaby BC V5G 1P2,1390000,7,4,House,15
R2510183,5712 Grant Street Burnaby BC V5B 2K4,1698000,3,4,House,18
R2512071,8154 Gilley Avenue Burnaby BC V5J 4Y5,2488000,9,9,House,1
R2510573,5059 Norfolk Street Burnaby BC V5G 1E9,1299000,4,4,House,7
R2512173,11226 236 Street Maple Ridge BC V2W 0C8 ,900000,4,4,House,35
R2512052,21560 Burnaby Court Maple Ridge BC V2X 8Z7,775000,3,2,House,43
R2508895,227-12258 224 Street Maple Ridge BC V2X 8Y7,474900,2,2,Condo,12
R2512451,102 Vancouver Court Coquitlam BC V3K 6E2,948000,4,2,House,20
R2512494,1803-1185 The High Street Coquitlam BC V3B 0A9,953000,3,2,Condo,10

Read more here: Source link