Hi all, I have a spreadsheet where the first cell in my row contains the information I need, but also contains over 400 words/characters that I don't need and the information I need is never in the same position. The info I need is a reference number that starts with 19.
First time poster, so take it easy on me
First time poster, so take it easy on me

I want to be able to paste this report, samples on rows 2 & 3. But I need to pull information from coloum a. I need the reference number only, found in the cell beginning withreferenceNumber (19. for example. End result should look like example below | ||||||||||||||
Booking ID (6024644), Object (1565335974), 6024644 Offloaded (false), 6024644 Model (false), 6024644 OnDemandBus (false), 6024644 SMSonApproachSent (null), 6024644 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024644 Status (COMPLETED), 6024644 queueEntryTime (null), 6024644 allowedZones (), 6024644 Queue (false), 6024644 EntryType (DISPATCH_CLIENT), 6024644 PhoneID (), 6024644 Is NoLoc? (false), 6024644 Is AutoDispatch? (true), 6024644 Reward Stars (null), 6024644 Reward Stars Reason (null), 6024644 Priority (NORMAL), 6024644 Pickup (Fri Jun 04 09:00:00 AEST 2021 [1622761200000] PRE - release time (600), class (class java.util.Date)), 6024644 Passenger # (1), 6024644 Addresses [# 2] (( [Address] ID (15039972) BookingID (6024644) Pass (1) DriverInfo () Name (LOVE smith) Phone (0362287051) Location ((-42.8489, 147.3006)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 09:00:00 AEST 2021 [1622761200000]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (PERONNE AVE) Area (MOONAH) GEO (99 PERONNE AVE, MOONAH),( [Address] ID (15039973) BookingID (6024644) Pass (0) DriverInfo () Name (LOVE smith) Phone (0362287051) Location ((-42.8896, 147.3195)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART DAY SURGERY 10 WARNEFORD ST) Area (SOUTH HOBART) GEO (HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART)), 6024644 Attributes ( Attributes: (Attribute ID[15], State[Ticked]![]() | FALSE | 6024644 | Fri Jun 04 09:00:00 AEST 2021 | 99 PERONNE AVE, MOONAH | LOVE smith | HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART | 50:01.0 | 57:26.0 | 11:31.0 | 77 | 3001313 | COMPLETED | Emily Gregory | |
Booking ID (6024636), Object (1979042151), 6024636 Offloaded (false), 6024636 Model (false), 6024636 OnDemandBus (false), 6024636 SMSonApproachSent (null), 6024636 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024636 Status (COMPLETED), 6024636 queueEntryTime (null), 6024636 allowedZones (), 6024636 Queue (false), 6024636 EntryType (DISPATCH_CLIENT), 6024636 PhoneID (), 6024636 Is NoLoc? (false), 6024636 Is AutoDispatch? (true), 6024636 Reward Stars (null), 6024636 Reward Stars Reason (null), 6024636 Priority (HIGH), 6024636 Pickup (Fri Jun 04 10:45:00 AEST 2021 [1622767500000] PRE - release time (900), class (class java.util.Date)), 6024636 Passenger # (1), 6024636 Addresses [# 2] (( [Address] ID (15042907) BookingID (6024636) Pass (1) DriverInfo (please drive down steep driveway to the unit , please call on arrival 0400754657/ ) Name (Phil smith) Phone (62479334) Location ((-42.9025, 147.4589)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 10:45:00 AEST 2021 [1622767500000]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (OAKDOWNS PARADE) Area (OAKDOWNS) GEO (99 OAKDOWNS PARADE, OAKDOWNS),( [Address] ID (15042908) BookingID (6024636) Pass (0) DriverInfo () Name (Phil smith) Phone (62479334) Location ((-42.8808, 147.3293)) Source (ZONEDEFAULT) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART CARDIOLOGY 25 ARGYLE ST) Area (HOBART) GEO (HOBART CARDIOLOGY 25 ARGYLE ST, HOBART)), 6024636 Attributes ( Attributes: (Attribute ID[15], State[Ticked];Attribute ID[16], State[Ticked];Attribute ID[18], State[Ticked]![]() | FALSE | 6024636 | Fri Jun 04 10:45:00 AEST 2021 | 99 OAKDOWNS PARADE, OAKDOWNS | PHil smith | HOBART CARDIOLOGY 25 ARGYLE ST, HOBART | 39:11.0 | 47:50.0 | 10:22.0 | 116 | 3003433 | COMPLETED | Emily Gregory | |
Example | ||||||||||||||
Booking ID (6024644), Object (1565335974), 6024644 Offloaded (false), 6024644 Model (false), 6024644 OnDemandBus (false), 6024644 SMSonApproachSent (null), 6024644 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024644 Status (COMPLETED), 6024644 queueEntryTime (null), 6024644 allowedZones (), 6024644 Queue (false), 6024644 EntryType (DISPATCH_CLIENT), 6024644 PhoneID (), 6024644 Is NoLoc? (false), 6024644 Is AutoDispatch? (true), 6024644 Reward Stars (null), 6024644 Reward Stars Reason (null), 6024644 Priority (NORMAL), 6024644 Pickup (Fri Jun 04 09:00:00 AEST 2021 [1622761200000] PRE - release time (600), class (class java.util.Date)), 6024644 Passenger # (1), 6024644 Addresses [# 2] (( [Address] ID (15039972) BookingID (6024644) Pass (1) DriverInfo () Name (LOVE smith) Phone (0362287051) Location ((-42.8489, 147.3006)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 09:00:00 AEST 2021 [1622761200000]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (PERONNE AVE) Area (MOONAH) GEO (99 PERONNE AVE, MOONAH),( [Address] ID (15039973) BookingID (6024644) Pass (0) DriverInfo () Name (LOVE smith) Phone (0362287051) Location ((-42.8896, 147.3195)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART DAY SURGERY 10 WARNEFORD ST) Area (SOUTH HOBART) GEO (HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART)), 6024644 Attributes ( Attributes: (Attribute ID[15], State[Ticked]![]() | 19557616 | 6024644 | Fri Jun 04 09:00:00 AEST 2021 | 99 PERONNE AVE, MOONAH | LOVE smith | HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART | 50:01.0 | 57:26.0 | 11:31.0 | 77 | 3001313 | COMPLETED | Emily Gregory | |
Booking ID (6024636), Object (1979042151), 6024636 Offloaded (false), 6024636 Model (false), 6024636 OnDemandBus (false), 6024636 SMSonApproachSent (null), 6024636 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024636 Status (COMPLETED), 6024636 queueEntryTime (null), 6024636 allowedZones (), 6024636 Queue (false), 6024636 EntryType (DISPATCH_CLIENT), 6024636 PhoneID (), 6024636 Is NoLoc? (false), 6024636 Is AutoDispatch? (true), 6024636 Reward Stars (null), 6024636 Reward Stars Reason (null), 6024636 Priority (HIGH), 6024636 Pickup (Fri Jun 04 10:45:00 AEST 2021 [1622767500000] PRE - release time (900), class (class java.util.Date)), 6024636 Passenger # (1), 6024636 Addresses [# 2] (( [Address] ID (15042907) BookingID (6024636) Pass (1) DriverInfo (please drive down steep driveway to the unit , please call on arrival 0400754657/ ) Name (Phil smith) Phone (62479334) Location ((-42.9025, 147.4589)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 10:45:00 AEST 2021 [1622767500000]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (OAKDOWNS PARADE) Area (OAKDOWNS) GEO (99 OAKDOWNS PARADE, OAKDOWNS),( [Address] ID (15042908) BookingID (6024636) Pass (0) DriverInfo () Name (Phil smith) Phone (62479334) Location ((-42.8808, 147.3293)) Source (ZONEDEFAULT) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART CARDIOLOGY 25 ARGYLE ST) Area (HOBART) GEO (HOBART CARDIOLOGY 25 ARGYLE ST, HOBART)), 6024636 Attributes ( Attributes: (Attribute ID[15], State[Ticked];Attribute ID[16], State[Ticked];Attribute ID[18], State[Ticked]![]() | 19555284 | 6024636 | Fri Jun 04 10:45:00 AEST 2021 | 99 OAKDOWNS PARADE, OAKDOWNS | PHil smith | HOBART CARDIOLOGY 25 ARGYLE ST, HOBART | 39:11.0 | 47:50.0 | 10:22.0 | 116 | 3003433 | COMPLETED | Emily Gregory |