Remove Characters Before /

Jack Harris
Celigo University Level 1: Skilled
Engaged

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

7 comments

Date Votes
  • Lakhan Bhagnani Integration Engineer
    Answer Pro

    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

    0
  • Jack Harris
    Celigo University Level 1: Skilled
    Engaged

    I tried {{regexReplace $.LineInformation.ExtendedDesc '' '.*\/'}} and got this

     

    0
  • Jack Harris
    Celigo University Level 1: Skilled
    Engaged

    And yes, you are interpreting correctly!

    0
  • Lakhan Bhagnani Integration Engineer
    Answer Pro

    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

    0
  • Jack Harris
    Celigo University Level 1: Skilled
    Engaged 
    {
      "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"
    }
    0
  • Kelly Izer Senior Solutions Consultant
    Awesome Follow-up
    Engaged
    Answer Pro
    Top Contributor
    Celigo University Level 4: Legendary

    Jack,

        If you just want the data after the / then I would suggest using the SPLIT function

    {{split myData "/" 1}}

     

     

    0
  • Jack Harris
    Celigo University Level 1: Skilled
    Engaged

    That did exactly what I needed it to. Thanks!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post