regexes for re-formatting spreadsheets

regexes.md

Start Time

=IF(H:H = "8AM-12PM","8:00 AM",
    IF(H:H = "12PM-4PM","12:00 PM",
        IF(H:H = "4PM-7:30PM","4:00 PM", 
        	IF(H:H = "AM(6:30AM-1:30PM)","6:30 AM", 
            	IF(H:H = "6:30 AM-1:30 PM","6:30 AM", 
                	IF(H:H = "PM(1:30PM-CLOSE)","1:30 PM", 
                		IF(H:H = "1:30PM-7:30PM","1:30 PM", "lolsorry")
                	)
                )
            )
        )
    )
)

End Time

=IF(H:H = "8AM-12PM","12:00 PM",
	IF(H:H = "12PM-4PM","4:00 PM",
		IF(H:H = "4PM-7:30PM","7:30 PM", 
			IF(H:H = "AM(6:30AM-1:30PM)","1:30 PM", 
				IF(H:H = "6:30 AM-1:30 PM","1:30 PM", 
					IF(H:H = "1:30PM-7:30PM","7:30 PM",
						IF(H:H = "PM(1:30PM-CLOSE)","7:30 PM", "lolsorry")
					)
				)
			)
		)
	)
)

LocationName

=REGEXEXTRACT(C:C, "^(.*?),")

Address

=REGEXEXTRACT(C:C, "\, (.*, NC) [0-9]+$")

Zip Code

=REGEXEXTRACT(C:C, "[0-9]+$")