Spreadsheet: 741306d1626960927-get-info-from-columns-u-and-ab-when-a-needed-text-sample
Sheet: Sheet1

[NAME] | Provider External ID | Provider Address | Order Local Time Zone | Order Reference ID | [NAME] | Delivery Type | Payment Method Type | Order Create Date | Order Create Datetime | Order Accepted Datetime | Prep Time Estimate Datetime | Order Marked Ready for Pickup | Courier Arrive Datetime | [NAME] | Order Delivered Datetime | Preparation Estimate error (minutes) | Rating | Rating Comment | Actor At Fault if Failed | Item Name | Item Category | Item Type | SKU | Option's Parent Item Name | Option's Parent Item SKU | Menu item tags | Item Amount | Provider Commission | Item Net Price | Item Price VAT Value | Item Gross Price
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 5LOG1 | delivered | regular | cashless | 2021-07-12 | 2021-07-12 00:18:50 | 2021-07-12 00:19:03 | 2021-07-12 00:53:47 | 2021-07-12 00:38:12 | 2021-07-12 00:44:22 | 2021-07-12 00:46:10 | 2021-07-12 00:59:22 | 18 |  |  |  | [NAME] (42 cm) | Pizzas (42 cm) | dish |  |  |  | Popular | 1 | 25 | 12.02 | 1.08 | 13.1
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 5LOG1 | delivered | regular | cashless | 2021-07-12 | 2021-07-12 00:18:50 | 2021-07-12 00:19:03 | 2021-07-12 00:53:47 | 2021-07-12 00:38:12 | 2021-07-12 00:44:22 | 2021-07-12 00:46:10 | 2021-07-12 00:59:22 | 18 |  |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | EHT9U | delivered | regular | cashless | 2021-07-12 | 2021-07-12 01:12:28 | 2021-07-12 01:13:03 | 2021-07-12 01:32:17 | 2021-07-12 01:34:26 | 2021-07-12 01:36:28 | 2021-07-12 01:40:01 | 2021-07-12 02:00:14 | 3 |  |  |  | BBQ sauce | Choose sauce: | option_multi_select |  | Choose sauce: |  |  | 1 | 25 | 0.92 | 0.08 | 1
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | EHT9U | delivered | regular | cashless | 2021-07-12 | 2021-07-12 01:12:28 | 2021-07-12 01:13:03 | 2021-07-12 01:32:17 | 2021-07-12 01:34:26 | 2021-07-12 01:36:28 | 2021-07-12 01:40:01 | 2021-07-12 02:00:14 | 3 |  |  |  | Buffalo chicken wings (spicy) | Snacks | dish |  |  |  |  | 1 | 25 | 4.94 | 0.45 | 5.39
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | EHT9U | delivered | regular | cashless | 2021-07-12 | 2021-07-12 01:12:28 | 2021-07-12 01:13:03 | 2021-07-12 01:32:17 | 2021-07-12 01:34:26 | 2021-07-12 01:36:28 | 2021-07-12 01:40:01 | 2021-07-12 02:00:14 | 3 |  |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | 4IBID | delivered | regular | cashless | 2021-07-12 | 2021-07-12 11:45:23 | 2021-07-12 11:46:34 | 2021-07-12 12:01:03 | 2021-07-12 12:03:31 | 2021-07-12 12:04:20 | 2021-07-12 12:05:50 | 2021-07-12 12:12:37 | -6 |  |  |  | Somali (42 cm) | Pizzas (42 cm) | dish |  |  |  |  | 1 | 25 | 12.02 | 1.08 | 13.1
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | HJIQY | delivered | regular | cashless | 2021-07-12 | 2021-07-12 19:46:36 | 2021-07-12 19:46:59 | 2021-07-12 20:01:10 | 2021-07-12 20:03:31 | 2021-07-12 20:03:17 | 2021-07-12 20:06:26 | 2021-07-12 20:20:50 | -6 |  |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 10X9P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:31:47 | 2021-07-12 20:32:05 | 2021-07-12 20:43:17 | 2021-07-12 20:42:05 | 2021-07-12 20:48:33 | 2021-07-12 20:53:01 | 2021-07-12 21:04:36 | -5 | 4 |  |  | [NAME] (42 cm) | Pizzas (42 cm) | dish |  |  |  |  | 1 | 25 | 11.74 | 1.06 | 12.8
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 10X9P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:31:47 | 2021-07-12 20:32:05 | 2021-07-12 20:43:17 | 2021-07-12 20:42:05 | 2021-07-12 20:48:33 | 2021-07-12 20:53:01 | 2021-07-12 21:04:36 | -5 | 4 |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 10X9P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:31:47 | 2021-07-12 20:32:05 | 2021-07-12 20:43:17 | 2021-07-12 20:42:05 | 2021-07-12 20:48:33 | 2021-07-12 20:53:01 | 2021-07-12 21:04:36 | -5 | 4 |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 10X9P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:31:47 | 2021-07-12 20:32:05 | 2021-07-12 20:43:17 | 2021-07-12 20:42:05 | 2021-07-12 20:48:33 | 2021-07-12 20:53:01 | 2021-07-12 21:04:36 | -5 | 4 |  |  | [NAME] | Choose sauce: | option_multi_select |  | Choose sauce: |  |  | 1 | 25 | 0.92 | 0.08 | 1
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | D01FR | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:33:42 | 2021-07-12 20:34:09 | 2021-07-12 20:49:03 | 2021-07-12 20:49:55 | 2021-07-12 20:50:28 | 2021-07-12 20:51:27 | 2021-07-12 21:08:11 | -6 | 5 |  |  | [NAME] (spicy) (42 cm) | Pizzas (42 cm) | dish |  |  |  |  | 1 | 25 | 12.02 | 1.08 | 13.1
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | D01FR | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:33:42 | 2021-07-12 20:34:09 | 2021-07-12 20:49:03 | 2021-07-12 20:49:55 | 2021-07-12 20:50:28 | 2021-07-12 20:51:27 | 2021-07-12 21:08:11 | -6 | 5 |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | G7KTK | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:59:43 | 2021-07-12 21:00:10 | 2021-07-12 21:18:10 | 2021-07-12 21:24:08 | 2021-07-12 21:10:33 | 2021-07-12 21:24:34 | 2021-07-12 21:29:56 | -2 |  |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | G7KTK | delivered | regular | cashless | 2021-07-12 | 2021-07-12 20:59:43 | 2021-07-12 21:00:10 | 2021-07-12 21:18:10 | 2021-07-12 21:24:08 | 2021-07-12 21:10:33 | 2021-07-12 21:24:34 | 2021-07-12 21:29:56 | -2 |  |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 6L11H | delivered | regular | cashless | 2021-07-12 | 2021-07-12 21:45:20 | 2021-07-12 21:45:35 | 2021-07-12 21:56:26 | 2021-07-12 22:01:46 | 2021-07-12 21:54:18 | 2021-07-12 22:04:56 | 2021-07-12 22:16:55 | -6 |  |  |  | Palermo (42 cm) | Pizzas (42 cm) | dish |  |  |  |  | 1 | 25 | 12.02 | 1.08 | 13.1
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 6L11H | delivered | regular | cashless | 2021-07-12 | 2021-07-12 21:45:20 | 2021-07-12 21:45:35 | 2021-07-12 21:56:26 | 2021-07-12 22:01:46 | 2021-07-12 21:54:18 | 2021-07-12 22:04:56 | 2021-07-12 22:16:55 | -6 |  |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 6L11H | delivered | regular | cashless | 2021-07-12 | 2021-07-12 21:45:20 | 2021-07-12 21:45:35 | 2021-07-12 21:56:26 | 2021-07-12 22:01:46 | 2021-07-12 21:54:18 | 2021-07-12 22:04:56 | 2021-07-12 22:16:55 | -6 |  |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | 6L11H | delivered | regular | cashless | 2021-07-12 | 2021-07-12 21:45:20 | 2021-07-12 21:45:35 | 2021-07-12 21:56:26 | 2021-07-12 22:01:46 | 2021-07-12 21:54:18 | 2021-07-12 22:04:56 | 2021-07-12 22:16:55 | -6 |  |  |  | BBQ sauce | Choose sauce: | option_multi_select |  | Choose sauce: |  |  | 1 | 25 | 0.92 | 0.08 | 1
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | CLD7P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 22:03:51 | 2021-07-12 22:04:03 | 2021-07-12 22:19:11 | 2021-07-12 22:21:18 | 2021-07-12 22:16:53 | 2021-07-12 22:27:32 | 2021-07-12 22:36:37 | -1 | 5 |  |  | Hawaii (42 cm) | Pizzas (42 cm) | dish |  |  |  |  | 1 | 25 | 11.47 | 1.03 | 12.5
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | CLD7P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 22:03:51 | 2021-07-12 22:04:03 | 2021-07-12 22:19:11 | 2021-07-12 22:21:18 | 2021-07-12 22:16:53 | 2021-07-12 22:27:32 | 2021-07-12 22:36:37 | -1 | 5 |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | CLD7P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 22:03:51 | 2021-07-12 22:04:03 | 2021-07-12 22:19:11 | 2021-07-12 22:21:18 | 2021-07-12 22:16:53 | 2021-07-12 22:27:32 | 2021-07-12 22:36:37 | -1 | 5 |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0
Pepperoni at Mr. [NAME] |  | Gedimino pr. 2a | Europe/Vilnius | CLD7P | delivered | regular | cashless | 2021-07-12 | 2021-07-12 22:03:51 | 2021-07-12 22:04:03 | 2021-07-12 22:19:11 | 2021-07-12 22:21:18 | 2021-07-12 22:16:53 | 2021-07-12 22:27:32 | 2021-07-12 22:36:37 | -1 | 5 |  |  | BBQ sauce | Choose sauce: | option_multi_select |  | Choose sauce: |  |  | 1 | 25 | 0.92 | 0.08 | 1
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | CCZVY | delivered | regular | cashless | 2021-07-13 | 2021-07-13 12:17:36 | 2021-07-13 12:17:46 | 2021-07-13 12:30:48 | 2021-07-13 12:25:51 | 2021-07-13 12:30:46 | 2021-07-13 12:32:07 | 2021-07-13 12:42:44 | -7 |  |  |  | Margarita (32 cm) | Pizzas (32 cm) | dish |  |  |  |  | 1 | 25 | 6.79 | 0.61 | 7.4
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | CCZVY | delivered | regular | cashless | 2021-07-13 | 2021-07-13 12:17:36 | 2021-07-13 12:17:46 | 2021-07-13 12:30:48 | 2021-07-13 12:25:51 | 2021-07-13 12:30:46 | 2021-07-13 12:32:07 | 2021-07-13 12:42:44 | -7 |  |  |  | Package fee | Package fee: | option_select |  | Package fee: |  |  | 1 | 25 | 0.28 | 0.02 | 0.3
Pepperoni Pizza ([NAME] str.) |  | [NAME] g. 73, Vilnius | Europe/Vilnius | CCZVY | delivered | regular | cashless | 2021-07-13 | 2021-07-13 12:17:36 | 2021-07-13 12:17:46 | 2021-07-13 12:30:48 | 2021-07-13 12:25:51 | 2021-07-13 12:30:46 | 2021-07-13 12:32:07 | 2021-07-13 12:42:44 | -7 |  |  |  | Medium | Choose pizza base: | option_select |  | Choose pizza base: |  |  | 1 | 25 | 0 |  | 0