I have some strings such as:
001 00001 POWER SEAT EA 10.0000 I
002 000YZ TRACK ASSY, SEAT OUTERDZ 1.0000 II
003 0X000 HOUSING SUB-ASSY, POWER SEAT, NO.1EA 12.0217 III
Each line contains Line Number, Item Number, Description, Unit of Mesure, Price and Price Type.
The problem is sometimes there is a whitespace between “Description” and “Unit of Mesure” (e.g. SEAT EA), and sometimes there isn’t (e.g. OUTERDZ)
Is there any way to find Unit of Measure from the original string and extract like: