Spreadsheet: 735137d1622715444-find-and-replace-a-word-in-a-cell-i-tried-everything-book1
Sheet: Sheet1

What it Currently looks like
Reference | Booking | Date | From | To | Pickup Time | Drop off Time | No
Booking ID (5956789), Object ([PHONE]), 5956789 Offloaded (false), [NAME] (false), 5956789 OnDemandBus (false), 5956789 SMSonApproachSent (null), 5956789 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 5956789 Status (COMPLETED), 5956789 queueEntryTime (null), 5956789 allowedZones (), 5956789 [NAME] (false), 5956789 EntryType ([NAME]), 5956789 PhoneID (), 5956789 Is [NAME]? (false), 5956789 Is AutoDispatch? (true), 5956789 Reward Stars (null), 5956789 Reward [NAME] (null), 5956789 Priority (NORMAL), 5956789 Pickup (Mon May 03 08:39:33 AEST 2021 [[PHONE]] ASAP), 5956789 Passenger # (1), 5956789 Addresses [# 2] (( [Address] ID (14834763) [NAME] (5956789) Pass (1) DriverInfo () Name (KILLION) Phone ([PHONE]) Location ((-42.8700, 147.3181)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Mon May 03 08:39:33 AEST 2021 [[PHONE]]) isPickup (true) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (MICRA 37 FEDERAL ST) Area (NORTH HOBART) GEO (MICRA 37 FEDERAL ST, NORTH HOBART),( [Address] ID (14834764) BookingID (5956789) Pass (0) DriverInfo () Name (KILLION) Phone ([PHONE]) Location ((-42.8828, 147.3222)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HERTZ AUTO RENT 122 HARRINGTON ST) Area (HOBART) GEO (HERTZ AUTO RENT 122 HARRINGTON ST, HOBART)), 5956789 Attributes ( Attributes: (Attribute ID[16], State[Ticked];)), 5956789 BookingFares ([BookingFares] bookingId (5956789) referenceNumber (M063106350) fareAmount (0.0) extrasAmount (0.0) accountAmount (0.0) requiresAccountRef (true) fixedPriceOnly (false) maxSubsidyPercent (0) maxSubsidyCents (0) requiresOdometer (false) m_bookingPayments obj ([[BookingPayments] bookingId (5956789) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (1) ReferenceNumber (M063106350) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)]) [BookingPayments] bookingId (5956789) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (1) ReferenceNumber (M063106350) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)), 5956789 Plotted? [NAME] (0) [NAME] (0) Time (null), 5956789 Client (Client Id (3704), Phone (NULL), Names (), Emails (), AccountIds (), Notes (NULL), DriverInfo (NULL) HashCodeWithAddresses ([PHONE]) HashCode ([PHONE]), Addresses (), Include Drivers (), [NAME] (), Include Vehicles (), [NAME] (), Attributes ()), 5956789 m_vehicleId (0), [NAME] (null), [NAME] (none), 5956789 Job (none), 5956789 Updates (1) ([BookingUpdate] Date (2021-05-03 08:39:33.0), operatorId (3000253), [NAME] (Booking Created), [NAME] details ([Existing Client, ]), debug (false));, 5956789 History (4), 5956789 ([BookingHistory] ID (28217089) status (OFFERED) offerId (9864284) when (2021-05-03 08:39:33.0) driverId (104989) vehicleId (141) offerZone (82) offerLoc ((-42.8745, 147.3141)) [NAME] (Same Zone - Waiting Longest) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 5956789 ([BookingHistory] ID (28217091) status (BOOKED) offerId (9864284) when (2021-05-03 08:39:33.0) driverId (104989) vehicleId (141) offerZone (82) offerLoc ((-42.8745, 147.3141)) endReason () [NAME] (7139577) jobSentDate (null) jobBookedDate (2021-05-03 08:39:35.0) jobPickupDate (null) jobCompleteDate (null));, 5956789 ([BookingHistory] ID (28217195) status (ENGAGED) offerId (9864284) when (2021-05-03 08:39:33.0) driverId (104989) vehicleId (141) offerZone (82) offerLoc ((-42.8745, 147.3141)) endReason (Started with DIGITAL IO) [NAME] (7139577) jobSentDate (2021-05-03 08:39:36.0) jobBookedDate (2021-05-03 08:39:35.0) jobPickupDate (2021-05-03 08:45:55.0) jobCompleteDate (null));, 5956789 ([BookingHistory] ID (28217279) status (COMPLETED) offerId (9864284) when (2021-05-03 08:39:33.0) driverId (104989) vehicleId (141) offerZone (82) offerLoc ((-42.8745, 147.3141)) endReason (Completed with DIGITAL IO) [NAME] (7139577) jobSentDate (2021-05-03 08:39:36.0) jobBookedDate (2021-05-03 08:39:35.0) jobPickupDate (2021-05-03 08:45:55.0) jobCompleteDate (2021-05-03 08:53:08.0)); | 6010000 | 2021-06-03 00:00:00 | [NAME] | Derwent Park | 02:00:00 | 03:00:00 | 26
What I need to look like
Reference | Booking | Date | From | To | Pickup Time | Drop off Time | No
(M063106350) | 6010000 | 2021-06-03 00:00:00 | [NAME] | Derwent Park | 02:00:00 | 03:00:00 | 26