Hello guys, I have an excel column like the following and I want to extract the string between two “|” that contains “weight”(it may be “weight” or “package weight” or something else, but containing “weight”) to another column. How can I do this? Thank you!
INCH/METRIC: Metric | KEY SIZE: 1.5, 2, 2.5, 3, 4, 5, 6, 8, 10 | NO. OF KEYS: 9 | TYPE: Magnetic Ball End | WEIGHT: 0.9 LB | EAN OR UPC: 82171566004
KEY SIZE: 0.050, 1/16, 5/64, 3/32, 7/64, 1/8, 9/64, 5/32, 3/16, 7/32, 1/4, 5/16, 3/8 | TYPE: Magnetic Ball End | NO. OF KEYS: 13 | INCH/METRIC: SAE | WEIGHT: 0.895 LB | EAN OR UPC: 82171566011
NO. OF KEYS: 22 | KEY SIZE: Includes 56601G, 56600G | TYPE: Magnetic Ball End | INCH/METRIC: SAE/Metric | WEIGHT: 0.725 LB | EAN OR UPC: 82171566028
INCH/METRIC: SAE | KEY SIZE: 0.050, 1/16, 5/64, 3/32, 7/64, 1/8, 9/64, 5/32, 3/16, 7/32, 1/4, 5/16, 3/8 | TYPE: Long Arm Hex | NO. OF KEYS: 13 | WEIGHT: 0.92 LB | EAN OR UPC: 82171566035
KEY SIZE: Includes 56601G, 56600G, 56605G | INCH/METRIC: SAE/Metric | NO. OF KEYS: 31 | TYPE: Master Magnetic | WEIGHT: 2.48 LB | EAN OR UPC: 82171566042
INCH/METRIC: Metric | NO. OF KEYS: 9 | TYPE: Long Arm Hex | KEY SIZE: 1.5, 2, 2.5, 3, 4, 5, 6, 8, 10 | WEIGHT: 0.8 LB | EAN OR UPC: 82171566066