Line Item Information5 ItemsCollapse allDescending1
Item1
GTIN123456.78901235
TPNDACDVFBGTYHIJIJK67890123456789012345
ProductDescriptionPFILOUS MOUSSE 4X71G123456789012345
QtyOrderedText1.23456789011234
QtyDeliveredText3333333.33333334
UOM
ConsumerUnitText100000000000.000
QtyReceivedText99.9999999999999
UOM_1
QtyDifferenceText1231231.23123123
StatusOver Shipped
DiscrepancyCodePartial Shipment
ChangeDescriptionSHORT678901234567890123456789012345 Item #GTIN TPND Product DescriptionQty OrderedQty DeliveredUOM Consumer UnitsQty ReceivedUOM Qty DifferenceStatus Discrepancy CodeChange DescriptionQty Charged2
Item2
GTIN11.2599
TPNDACDVFBGTYHIJIJK67890123456789012345
ProductDescriptionPFILOUS MOUSSE 4X71G123456789012345
QtyOrderedText18.995
QtyDeliveredText9.566
UOM
ConsumerUnitText10.25
QtyReceivedText11.26
UOM_1
QtyDifferenceText102.58
StatusOver Shipped
DiscrepancyCodePartial Shipment
ChangeDescriptionSHORT678901234567890123456789012345 Item #GTIN TPND Product DescriptionQty OrderedQty DeliveredUOM Consumer UnitsQty ReceivedUOM Qty DifferenceStatus Discrepancy CodeChange DescriptionQty Charged3
Item3
GTIN33297794900181
TPNDACDVFBGTYHIJIJK67890123456789012345
ProductDescriptionPFILOUS MOUSSE 4X71G123456789012345
QtyOrderedText123456789012345
QtyDeliveredText123456789012345
UOM
ConsumerUnitText123456789012345
QtyReceivedText123456789012345
UOM_1
QtyDifferenceText123456789012345
StatusOver Shipped
DiscrepancyCodePartial Shipment
ChangeDescriptionSHORT678901234567890123456789012345 Item #GTIN TPND Product DescriptionQty OrderedQty DeliveredUOM Consumer UnitsQty ReceivedUOM Qty DifferenceStatus Discrepancy CodeChange DescriptionQty Charged4
Item4
GTIN33297794900181
TPNDACDVFBGTYHIJIJK67890123456789012345
ProductDescriptionPFILOUS MOUSSE 4X71G123456789012345
QtyOrderedText123456789012345
QtyDeliveredText123456789012345
UOM
ConsumerUnitText123456789012345
QtyReceivedText123456789012345
UOM_1
QtyDifferenceText123456789012345
StatusOver Shipped
DiscrepancyCodePartial Shipment
ChangeDescriptionSHORT678901234567890123456789012345 Item #GTIN TPND Product DescriptionQty OrderedQty DeliveredUOM Consumer UnitsQty ReceivedUOM Qty DifferenceStatus Discrepancy CodeChange DescriptionQty Charged5
Item5
GTIN33297794900181
TPNDACDVFBGTYHIJIJK67890123456789012345
ProductDescriptionPFILOUS MOUSSE 4X71G123456789012345
QtyOrderedText123456789012345
QtyDeliveredText123456789012345
UOM
ConsumerUnitText123456789012345
QtyReceivedText123456789012345
UOM_1
QtyDifferenceText123456789012345
StatusOver Shipped
DiscrepancyCodePartial Shipment
ChangeDescriptionSHORT678901234567890123456789012345 Item #GTIN TPND Product DescriptionQty OrderedQty DeliveredUOM Consumer UnitsQty ReceivedUOM Qty DifferenceStatus Discrepancy CodeChange DescriptionQty Charged10 per page5 results
1 of 1
PalletPallet 12&!#
SSCC CodeRECIEVEADVICE 123456789ABCDEFGHIJKL Pallet #SSCC Code
I am using this regex (GTIN)(?.+)(?(?=Item)) to get the values of the labels but i am also getting some unwanted noise data.
Help me to remove that part and if it is possible to get the generalize form
GTIN is a label like that item, uom these all are different labels