I need to scrap address, phone number and operation hours on daily basis separately from the group of below strings. Could someone help me on this?
“1111MiStreetSanFrancisco,CA44000,USA 222-4444-1111 Hours Sunday 9:00AM-8:00PM Monday 7:00AM-9:00PM Tuesday 7:00AM-9:00PM Wednesday 7:00AM-9:00PM Thursday 7:00AM-9:00PM Friday 7:00AM-9:00PM Saturday 8:00AM-9:00PM”
I need address field with the value “1111MiStreetSanFrancisco,CA44000,USA”
Phone Number field = “222-4444-1111”
Sunday = “9:00AM-8:00PM”, Monday, Tuesday for all the days in separate field or variable