I hope someone is able to assist with this Excel formula. I need a custom Trim performed in a column. I need everything before the last occurrence of the word "Patch" plus the following character Trimmed out. For example the final result should be "PatchJ" or "PatchM" etc... NOTE The last occurrence of the word Patch is not always directly at the end of the string. Example images of this variances are attached (Highlighting in yellow the word I need to keep)...
Here is a sample of two variances to be copied from:
Need to keep "PatchJ" (It IS acceptable to keep the previous four numbers as well "1326PatchJ"
1511 13_26/core 13_26/system 13_26/3rdParty 13_26/NgVtuCfg/FixedSimmons 13_26/NMDTIni/FixedRoute 13_26/NMotorolaSB9600RadioDriverIni/Reband 13_26/NRfCommsSubsystemIni/FixedSimmons 13_26/NWirelessLANSubsystemIni/Fixed 13_26/OdoConfigIni/NewFlyer670 13_26/systemIni/Fixed 13_26/Logging/std 13_26/RadioConfigIni/Reband/Pri2Sec1 13_26/IRQ_Init_TableDat/DCM 13_26/1326PatchA/NMotorolaSB9600RadioDriverIni/Reband 13_26/1326PatchA/DR 13_26/1326PatchA/1326PatchA 13_26/1326PatchA/NMDTIni/FixedRoute 13_26/1326PatchA/RadioConfigIni/Reband/Fallback18/Pri3Sec1 13_26/1326PatchB/1326PatchB 13_26/1326PatchD/1326PatchD 13_26/1326PatchC/1326PatchC 13_26/1326PatchC/NMDTIni/FixedRoute 13_26/1326PatchE/1326PatchE 13_26/1326PatchE/DR 13_26/1326PatchE/RadioConfigIni/Reband/Fallback18/Pri2Sec3 13_26/1326PatchF/1326PatchF 13_26/1326PatchF/NFareboxSubsystemIni/Build13 13_26/1326PatchF/systemIni/Fixed 13_26/1326PatchH/1326PatchH 13_26/1326PatchI/1326PatchI 13_26/1326PatchJ/1326PatchJ
and
Need to keep "PatchP" (It IS acceptable to keep the previous four numbers as well "1603PatchP"
166141 16_03/core 16_03/system 16_03/3rdParty 16_03/NgVtuCfg/FixedSimmons 16_03/NMotorolaSB9600RadioDriverIni/Reband 16_03/NRfCommsSubsystemIni/FixedSimmons 16_03/NWirelessLANSubsystemIni/Build16/Fixed 16_03/OdoConfigIni/NewFlyer670 16_03/systemIni/Build16/Fixed 16_03/Logging/on 16_03/RadioConfigIni/Common 16_03/amdtStart/NoExtSignDownload 16_03/NVehicleMonitoringSubsystemIni/Build16 16_03/1603PatchA/1603PatchA 16_03/1603PatchA/NMotorolaSB9600RadioDriverIni/Reband 16_03/1603PatchA/RadioConfigIni/Reband/Pri1Sec3 16_03/1603PatchB/drconfigIni/Build16 16_03/1603PatchB/1603PatchB 16_03/1603PatchC/1603PatchC 16_03/1603PatchC/RadioConfigIni/Reband/Fallback17/Pri1Sec3 16_03/1603PatchD/1603PatchD 16_03/1603PatchE/1603PatchE 16_03/1603PatchE/FunctionalHwConfigIni/BikeRequest 16_03/1603PatchE/NAnnunciatorSubsystemIni/BikeRequest 16_03/1603PatchF/1603PatchF 16_03/1603PatchG/1603PatchG 16_03/1603PatchG/DR 16_03/1603PatchG/RadioConfigIni/Reband/Fallback17/Pri1Sec3 16_03/1603PatchH/1603PatchH 16_03/1603PatchI/1603PatchI 16_03/1603PatchI/NFareboxSubsystemIni/Build16 16_03/1603PatchI/systemIni/Build16/Fixed 16_03/1603PatchK/1603PatchK 16_03/1603PatchL/1603PatchL 16_03/1603PatchL/NAnnunciatorSubsystemIni/BikeRequest 16_03/1603PatchM/1603PatchM 16_03/1603PatchN/1603PatchN 16_03/1603PatchP/1603PatchP 16_03/1603PatchP/Logging/dmp 16_03/1603PatchP/NEthernetCommDriverIni/FieldDebug 16_03/1603PatchP/NGprsSubsystemIni/Fallback17 16_03/1603PatchP/NMotorolaSB9600RadioDriverIni/Reband 16_03/1603PatchP/systemIni/Build16/Fixed_Cellular
Source String.JPG
DataFields.JPG
I know this is a unique request, I have gotten close by trial and error, but I just couldn't quite get it. If needed additional helper columns can be created to get the final result desired.
Truly thank you in advance for any assistance that can be provided.
Bookmarks