Remove Characters Before /
Here's my value 12/007365121440. I'm trying to remove the characters before the /. I tried using a regexReplace and a regexMatch, but I'm having a hard time understanding what the full Handlebar should be. Any suggestions?
0
Comments
Hey Jack
As per my understanding, you want everything to be removed before forward slash "/"
This below handlebar I have used to replace everything before "/" with empty string
{{regexReplace value '' '.*\/'}}Let me know if I am interpreting it incorrectly.
Regards,
Lakhan Bhagnani
I tried {{regexReplace $.LineInformation.ExtendedDesc '' '.*\/'}} and got this
And yes, you are interpreting correctly!
Hey Jack,
Removing all the PII, can you paste the Mock Data here? As per the error message, it means that the field you referenced doesn't exist in the data.
Regards,
Lakhan Bhagnani
{"HeaderInformation": [
{
"CODE CLIENT": "MAR08"
},
{
"TRXSet": "ASN"
},
{
"ROUTE": "MAR08"
},
{
"COMPANY": "W1"
}
],
"ReferenceInformation": [
{
"ReportingCode": "0",
"DepositorOrderNumber": "269358",
"Date": "20240325",
"ShipmentID": "",
"Agent Shipment ID": "2097014",
"PurchaseOrderNumber": "10009626",
"AlternateReference1": "",
"LoadNumber": "0120",
"SpecialHandlingCode": "",
"ReasonCode": "",
"TransactionTypeCode": "",
"ActionCode": "",
"Tracking_Number": "002097014",
"Reference1": "0244185840000",
"Reference2": "ASN",
"Reference3": "MARING2871",
"Reference4": "0002064",
"LoadExternalNumber": "",
"CarrierProNumber": "",
"Names": [
{
"OrganizationIDCode": "WH",
"Name": "Distribution"
},
{
"OrganizationIDCode": "DE",
"Name": "FOODS"
},
{
"OrganizationIDCode": "ST",
"Name": "MARKETS INC",
"IDType": "91",
"EntityCode": "0244185840000"
}
],
"Addresses": [
{
"Address1": "WAREHOUSE 2913",
"Address2": "US HIGHWAY WEST",
"Address3": "",
"Address4": ""
}
],
"GeographicLocation": [
{
"City": "MOUNTAIN",
"State": "",
"Zip": "",
"Country": "US"
}
],
"DateTimes": [
{
"DateQualifier": "02",
"Date": "20240325"
},
{
"DateQualifier": "10",
"Date": "20240325"
},
{
"DateQualifier": "52",
"Date": "20240311"
}
],
"WarehouseCarrierInformation": [
{
"TransportationMethod": "H",
"SCAC": "CPU",
"Routing": "CUSTOMER PICK-UP",
"MethodofPayment": "CC",
"EquipmentDescriptionCode": "",
"EquipmentInitial": "",
"EquipmentNumber": "",
"ShipmentOrderStatusCode": "",
"SpecialHandlingCode": "",
"CarrierChangeReasonCode": "",
"PowerUnitNumber": "",
"CarryUnitNumber": "",
"VesselNumber": "",
"VoyageNumber": ""
}
],
"ConsolidationInformation": [
{
"PackagingCode": "PLT49",
"LadingQuantity": "1373",
"Weight": "14278.7",
"WeightQualifier": "G",
"WgtUOM": "LB"
}
],
"WarehouseAdditionalCarrierInfo": []
}
],
"LineInformation": [
{
"AssignedNumber": "000001",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "11",
"ShippedQuantity": "11",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112862",
"Level2": "SEP122025",
"Level3": "355122",
"Level4": "",
"GrsWgt": "85.25",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "85.25",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695488",
"ExpiryDate": "20250912",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM STRAWBERRY",
"AlternateItemDesc": "STRAWBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112862"
},
{
"AssignedNumber": "000002",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "31",
"ShippedQuantity": "31",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112862",
"Level2": "SEP122025",
"Level3": "355128",
"Level4": "",
"GrsWgt": "240.25",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "240.25",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695488",
"ExpiryDate": "20250912",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM STRAWBERRY",
"AlternateItemDesc": "STRAWBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112862"
},
{
"AssignedNumber": "000003",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "44",
"ShippedQuantity": "44",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365151221",
"Level2": "MAR222026",
"Level3": "345107",
"Level4": "",
"GrsWgt": "677.60",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "677.60",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695495",
"ExpiryDate": "20260322",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "135-1 12/7 LOW SALT ST MZ",
"AlternateItemDesc": "12/7 OZ JAR MARIO SMT REDUCED SALT - PAR",
"ExtendedDesc": "12/007365151221"
},
{
"AssignedNumber": "000004",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "41",
"ShippedQuantity": "41",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121440-DEHK",
"Level2": "030326",
"Level3": "345453",
"Level4": "",
"GrsWgt": "492.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "492.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695501",
"ExpiryDate": "20260303",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "921 12/6 EXLARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ TIN TRAY MARIO EX LG BLACK PITTED",
"ExtendedDesc": "12/007365121440"
},
{
"AssignedNumber": "000005",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "4",
"ShippedQuantity": "4",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121440-DEHK",
"Level2": "030326",
"Level3": "345464",
"Level4": "",
"GrsWgt": "48.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "48.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695501",
"ExpiryDate": "20260303",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "921 12/6 EXLARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ TIN TRAY MARIO EX LG BLACK PITTED",
"ExtendedDesc": "12/007365121440"
},
{
"AssignedNumber": "000006",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "90",
"ShippedQuantity": "90",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121428-WA",
"Level2": "DEC232025",
"Level3": "342186",
"Level4": "",
"GrsWgt": "1170.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1170.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695518",
"ExpiryDate": "20251223",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "916 12/6 LARGE PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO LARGE BLACK PITTED",
"ExtendedDesc": "12/007365121428"
},
{
"AssignedNumber": "000007",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "10",
"ShippedQuantity": "10",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353782",
"Level4": "",
"GrsWgt": "120.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "120.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000008",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "1",
"ShippedQuantity": "1",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353782",
"Level4": "",
"GrsWgt": "12.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "12.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000009",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "97",
"ShippedQuantity": "97",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111746",
"Level2": "DEC212025",
"Level3": "353784",
"Level4": "",
"GrsWgt": "1164.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1164.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695525",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "12/6 OZ JAR MARIO SALAD",
"AlternateItemDesc": "12/6 OZ JAR MARIO SALAD",
"ExtendedDesc": "12/007365111746"
},
{
"AssignedNumber": "000010",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "9",
"ShippedQuantity": "9",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121422",
"Level2": "JAN242026",
"Level3": "341306",
"Level4": "",
"GrsWgt": "117.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "117.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695532",
"ExpiryDate": "20260124",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "911 12/6 MEDIUM PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO MEDIUM BLACK PITTED",
"ExtendedDesc": "12/007365121422"
},
{
"AssignedNumber": "000011",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "126",
"ShippedQuantity": "126",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121422",
"Level2": "JAN242026",
"Level3": "341313",
"Level4": "",
"GrsWgt": "1638.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1638.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695532",
"ExpiryDate": "20260124",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "911 12/6 MEDIUM PITTED RIPE OLIVES",
"AlternateItemDesc": "12/6 OZ CAN MARIO MEDIUM BLACK PITTED",
"ExtendedDesc": "12/007365121422"
},
{
"AssignedNumber": "000012",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "41",
"ShippedQuantity": "41",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111710-A",
"Level2": "DEC222025",
"Level3": "339560",
"Level4": "",
"GrsWgt": "759.32",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "759.32",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695549",
"ExpiryDate": "20251222",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES STF W/PIMIENTO",
"AlternateItemDesc": "STUFFED WITH PIMIENTO",
"ExtendedDesc": "6/007365111710"
},
{
"AssignedNumber": "000013",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "19",
"ShippedQuantity": "19",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111710-A",
"Level2": "DEC222025",
"Level3": "339564",
"Level4": "",
"GrsWgt": "351.88",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "351.88",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695549",
"ExpiryDate": "20251222",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES STF W/PIMIENTO",
"AlternateItemDesc": "STUFFED WITH PIMIENTO",
"ExtendedDesc": "6/007365111710"
},
{
"AssignedNumber": "000014",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "68",
"ShippedQuantity": "68",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651161314",
"ItemCode": "7365179702",
"Level2": "SEP262025",
"Level3": "356143",
"Level4": "",
"GrsWgt": "482.80",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "482.80",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695556",
"ExpiryDate": "20250926",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN CASTLEVELTRANO OLIVES 160/180",
"AlternateItemDesc": "PITTED GREEN CASTELEVELTRANO OLIVES",
"ExtendedDesc": "6/007365179702"
},
{
"AssignedNumber": "000015",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "50",
"ShippedQuantity": "50",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111833",
"Level2": "MAR142026",
"Level3": "345510",
"Level4": "",
"GrsWgt": "225.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "225.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695563",
"ExpiryDate": "20260314",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "SLCD GREEN OLIVES 12/2.25OZ",
"AlternateItemDesc": "12/2.25 OZ CAN MARIO SLICED GREEN",
"ExtendedDesc": "12/007365111833"
},
{
"AssignedNumber": "000016",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "12",
"ShippedQuantity": "12",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365116132",
"Level2": "JUN222025",
"Level3": "351544",
"Level4": "",
"GrsWgt": "94.80",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "94.80",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695570",
"ExpiryDate": "20250622",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH FETA CHEESE",
"ExtendedDesc": "6/007365116132"
},
{
"AssignedNumber": "000017",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "26",
"ShippedQuantity": "26",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365116132",
"Level2": "JUN222025",
"Level3": "351552",
"Level4": "",
"GrsWgt": "205.40",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "205.40",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695570",
"ExpiryDate": "20250622",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH FETA CHEESE",
"ExtendedDesc": "6/007365116132"
},
{
"AssignedNumber": "000018",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "68",
"ShippedQuantity": "68",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111706",
"Level2": "OCT282025",
"Level3": "360577",
"Level4": "",
"GrsWgt": "817.36",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "817.36",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695587",
"ExpiryDate": "20251028",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "133 12/5.75OZ STUFFED GREEN OLIVES W/PIM",
"AlternateItemDesc": "STUFFED GREEN OLIVE STUFFED W PIMIENTO",
"ExtendedDesc": "12/007365111706"
},
{
"AssignedNumber": "000019",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "34",
"ShippedQuantity": "34",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365111706",
"Level2": "OCT282025",
"Level3": "360578",
"Level4": "",
"GrsWgt": "408.68",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "408.68",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695587",
"ExpiryDate": "20251028",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "133 12/5.75OZ STUFFED GREEN OLIVES W/PIM",
"AlternateItemDesc": "STUFFED GREEN OLIVE STUFFED W PIMIENTO",
"ExtendedDesc": "12/007365111706"
},
{
"AssignedNumber": "000020",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "51",
"ShippedQuantity": "51",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121470-WA",
"Level2": "122125",
"Level3": "341208",
"Level4": "",
"GrsWgt": "663.00",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "663.00",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695594",
"ExpiryDate": "20251221",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "931 12/5.75 JUMBO PITTED RIPE OLIVES",
"AlternateItemDesc": "12/5.75 OZ CAN MARIO JUMBO BLACK PITTED",
"ExtendedDesc": "12/007365121470"
},
{
"AssignedNumber": "000021",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "149",
"ShippedQuantity": "149",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121405",
"Level2": "DEC192025",
"Level3": "339423",
"Level4": "",
"GrsWgt": "1385.70",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1385.70",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695600",
"ExpiryDate": "20251219",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "980 24/2.25 SLICED RIPE OLIVES TRAY PACK",
"AlternateItemDesc": "24/2.25 OZ CAN MARIO SLICED BLACK OLIVE TRAY PK",
"ExtendedDesc": "24/007365121405"
},
{
"AssignedNumber": "000022",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "71",
"ShippedQuantity": "71",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365121405",
"Level2": "DEC192025",
"Level3": "339424",
"Level4": "",
"GrsWgt": "660.30",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "660.30",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695600",
"ExpiryDate": "20251219",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "980 24/2.25 SLICED RIPE OLIVES TRAY PACK",
"AlternateItemDesc": "24/2.25 OZ CAN MARIO SLICED BLACK OLIVE TRAY PK",
"ExtendedDesc": "24/007365121405"
},
{
"AssignedNumber": "000023",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "198",
"ShippedQuantity": "198",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651214089",
"ItemCode": "7365121408",
"Level2": "FEB102026",
"Level3": "342777",
"Level4": "",
"GrsWgt": "1514.70",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "1514.70",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695617",
"ExpiryDate": "20260210",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "SLICED RIPE 12/3.8 TIN",
"AlternateItemDesc": "SLICED RIPE 12/3.8 TIN",
"ExtendedDesc": "12/007365121408"
},
{
"AssignedNumber": "000024",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "42",
"ShippedQuantity": "42",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112864",
"Level2": "SEP132025",
"Level3": "356605",
"Level4": "",
"GrsWgt": "325.50",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "325.50",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695624",
"ExpiryDate": "20250913",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREMIUM RASPBERRY",
"AlternateItemDesc": "RASPBERRY FRUIT SPREAD",
"ExtendedDesc": "8/007365112864"
},
{
"AssignedNumber": "000025",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "38",
"ShippedQuantity": "38",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "073651161338",
"ItemCode": "7365116133",
"Level2": "NOV132026",
"Level3": "359731",
"Level4": "",
"GrsWgt": "293.36",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "293.36",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695631",
"ExpiryDate": "20261113",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "GREEN OLIVES",
"AlternateItemDesc": "STUFFED WITH REAL PIMIENTO. OLIVES",
"ExtendedDesc": "6/007365116133"
},
{
"AssignedNumber": "000026",
"itemDetail": [
{
"OrderStatusCode": "CC",
"OrderedQuantity": "42",
"ShippedQuantity": "42",
"QuantityDifference": "0",
"UOM": "CA",
"UPCCaseCode": "",
"ItemCode": "7365112867",
"Level2": "DEC162024",
"Level3": "355159",
"Level4": "",
"GrsWgt": "326.76",
"GrsWgtQ": "G",
"GrsWgtU": "L",
"NetWgt": "326.76",
"NetWgtQ": "N",
"NetWgtU": "L",
"SSCC18": "00107291480053695655",
"ExpiryDate": "20241216",
"Number": "",
"CarrierTrackingNumber": "",
"AlternateItemDescription": ""
}
],
"ItemDescription": "FRUIT SPREAD PREM 8/GLTRY PK APRICOT",
"AlternateItemDesc": "APRICOT FRUIT SPREAD",
"ExtendedDesc": "8/007365112867"
}
],
"NumberofUnitsShipped": "1373",
"TotalWeight": "14278.7",
"UOM": "LB"
}
Jack,
If you just want the data after the / then I would suggest using the SPLIT function
{{split myData "/" 1}}
That did exactly what I needed it to. Thanks!
Please sign in to leave a comment.