i have a field like the below and want to separate out the red and the green into 2 separate fields. any help ?
9900-10 ABC 1300-7/1.4|EXTRATYPE_M|1111_1_1.100 |
9900-2 ABC 1100-4/0.58|EXTRATYPE_M|1100_1_0.110 |
234-102 ABC 360-1/1600|TYPE|V36011100 |
234-13 ABC 6400R/2.5-120|TYPE|V11110 |
234-139 ABC 6700XXX-245/2.90|TYPE|6700ABC_111_9.99 |
234-42 ABC 4400L/30|TYPE|VV30 |
234-7 ABC 2400 / 10cm X2004|TYPE|x110010 |
234-97 ABC 2600-12/1.99|TYPE|V2600_11_111 |
Screenshot of Regex101.com
wow this very detailed @csmith11 😀