The HSDS schedule format has a "Weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (can be separated by commas, in a spreadsheet). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".
Secondly, please help separate "fulladdr" by commas, transforming "28270 Huntwood Ave, Hayward, CA 94544" into address_1 = "28270 Huntwood Ave", city = "Hayward", state = CA and zip = "94544"
Transform the "operhours" field from the COVID-19 testing site scraped data (https://docs.google.com/spreadsheets/d/1hk2ZE5YfcJ4USziKbcsPf-aX9q_HkZiJZmjDK52SG28/edit?usp=sharing) into HSDS format, in a Google Spreadsheet.
The HSDS schedule format has a "Weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (can be separated by commas, in a spreadsheet). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".
Here is an example of the proper format: https://airtable.com/shrj6PK4Gv4IwojLZ/tblHJYRukIcbqZpkk. (It does not include add_day and add_hour, but for examples of that, you can scroll through the "schedule" tab of our entire database: https://airtable.com/tblNUH1g3IIOlP7NB/viwAvkwqEAjtXgxtV?blocks=hide)
Secondly, please help separate "fulladdr" by commas, transforming "28270 Huntwood Ave, Hayward, CA 94544" into address_1 = "28270 Huntwood Ave", city = "Hayward", state = CA and zip = "94544"