I need to extract the time range and location from a variable "Itemproperties".  I'm having difficulty bc some location have 2 delimerters ("@") and others will have 1. Also the substr would not work bc the position of the characters are not consistent.   Data:     Data: Itemproperties Pickup Details:6. 11/21 SAT    4:40 - 5:00 @ Mountain View @ Ranch 99 Pickup Details:6. 11/21 SAT 5:30 - 5:50 @ Cupertino Pickup Details:5.      10/23 FRI 4:40 - 5:00 @     W. SJ @   Starbucks     want: location                                                 time Mountain View @ Ranch 99                  4:40 - 5:00 Cupertino                                               5:30 - 5:50 W. SJ @ Starbucks                                4:40 - 5:00 ... View more

I need to extract the time range and location from a variable "Itemproperties".  I'm having difficulty bc some location have 2 delimerters ("@") and others will have 1.   Data: Data: Itemproperties Pickup Details:6. 11/21 SAT 4:40 - 5:00 @ Mountain View @ Ranch 99 Pickup Details:6. 11/21 SAT 5:30 - 5:50 @ Cupertino Pickup Details:5. 10/23 FRI 4:40 - 5:00 @ W. SJ @ Starbucks     want: location                                                 time Mountain View @ Ranch 99                  4:40 - 5:00 Cupertino                                               5:30 - 5:50 W. SJ @ Starbucks                                4:40 - 5:00   ... View more

Hi,   I have a dataset consisting: customers, food vendors,  and order date .   Since customers can order from multiple food vendors within the same day, I need to figure out the frequencies and  %'s  of Vender A,B,C,etc. being ordered together within the same day.    dataset: Name       Vendor       Order_date Bob            A               1-1-2020 Bob            A               1-1-2020 Bob            B               1-1-2020 Joe            A                1-2-2020 Joe            B                1-2-2020 Chris         A                 1-1-2020 Chris         B                 1-2-2020 David        C                 1-3-2020 David        A                 1-3-2020 David        B                 1-3-2020     want: Vendor_comb       count A, B                         3       bc Vendor A & B  were ordered 3 times within the same day  from Bob, Joe, David.  Chris does not count bc he ordered on different days.  Thanks         ... View more