Published
Edited
Sep 21, 2022
Insert cell
Insert cell
Insert cell
Insert cell
metadata=tr1.split('br')
Insert cell
locationDetails= [metadata[0], metadata[1], metadata [2], metadata[3]]
Insert cell
searchName= metadata[0].search("Union")
Insert cell
locationName=metadata[0].substring(177,197)
Insert cell
cleanaddressName= metadata[1].search("AA IT WORKS II - AA It Works II")
Insert cell
addressName= metadata[1].substring(18, 49)
Insert cell
cleanAddress= metadata[2].search(240)
Insert cell
unionAddress= metadata[2].substring(10, 31)
Insert cell
cleanUnionDirections= metadata[3].search("Betw")
Insert cell
unionDirection= metadata[3].substring(4,22)
Insert cell
cleanState= metadata[3].search("NY")
Insert cell
state= metadata[3].substring(28, 36)
Insert cell
unionAddressArray= [addressName, unionAddress,unionDirection, state]
Insert cell
meetingTimeDetails = tr1.split (' <br />' )
Insert cell
timeList= [meetingTimeDetails[1],meetingTimeDetails[2],meetingTimeDetails[3],meetingTimeDetails[4]]
Insert cell
time1= timeList[0].substring(510,560).replace("</b>","").replace("<b>","").replace("</b>","")
Insert cell
time2= timeList[1].substring(121,180).replace("</b>","").replace("<b>","").replace("</b>","")
Insert cell
time3= timeList[2].substring(121,180).replace("</b>","").replace("<b>","").replace("</b>","")
Insert cell
time4= timeList[3].substring(116,180).replace("</b>","").replace("<b>","").replace("</b>","")
Insert cell
timeArray= [time1,time2,time3,time4]
Insert cell
meetingType1= meetingTimeDetails[2].substring(3,41).replace("</b>", "")
Insert cell
meetingType2= meetingTimeDetails[3].substring(3,41).replace("</b>", "")
Insert cell
meetingType3= meetingTimeDetails[4].substring(3,36).replace("</b>", "")
Insert cell
meetingType4= meetingTimeDetails[5].substring(3,40).replace("</b>", "")
Insert cell
meetingTypeArray = [meetingType1, meetingType2,meetingType3,meetingType4]
Insert cell
wheelChairAccess = tr1.split('img src="../images/wheelchair.jpg')
Insert cell
wheelChairArray = [wheelChairAccess[1].substring(7,24)]
Insert cell
unionArray= [
unionAddressArray,
timeArray,
meetingTypeArray,
wheelChairArray
]
Insert cell
timeString = "Wednesdays From 10:30 AM to 11:00 AM"
Insert cell
function convertTimestring (rawText) {
var newTimestring = {}
var myName = 'Aaron'
newTimestring.day = (rawText.split(' ')[0])
newTimestring.startTime = rawText.split('From')[1].trim().split(' to ')[0]
newTimestring.startTimeAmPm = rawText.split('From')[1].trim().split(' to ')[0].split(' ')[1]
newTimestring.endTime = rawText.split('From')[1].trim().split(' to ')[1]
newTimestring.startTimeNumeric = rawText.split('From')[1].trim().split(' to ')[0].split(':')[0] * 1 + rawText.split('From')[1].trim().split(' to ')[0].split(':')[1].split(' ')[0] * 1 / 60
// if (rawText.split('From')[1].trim().split(' to ')[0].split(' ')[1] == 'PM') {}
// newTimestring.startTimeMinutesNumeric = rawText.split('From')[1].trim().split(' to ')[0].split(':')[1].split(' ')[0] * 1 / 60
newTimestring.endTimeNumeric = rawText.split('From')[1].trim().split(' to ')[1].split(':')[0] * 1
return newTimestring
}
Insert cell
convertTimestring(timeString)
Insert cell
convertTimestring("Fridays From 1:00 PM to 2:00 PM")
Insert cell
10 + ("3" * 1)
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more