Separate strings from a field

[Sammy22]

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

[csmith11]

Here's some quick Regex:

(\d+-\d+)\s([^|]*)|.*

See Solution Attached:

[csmith11]

Screenshot of Regex101.com

[atcodedog05]

wow this very detailed @csmith11 😀

[ponraj]

Text to column tool can also help.