Bifurcation of Characteristic Value from the UOM into other column

Hello Everyone,

I am on BI 7.4 version. I have a Characteristic Value for a Material as WD (Width) which has a UOM as MM and Inches which comes as dimension in the Source. Please see the below screen shot for the same.

Order Material Customer WD Char1 Char2 S001 M001 C001 43.995 mm 43.995 mm S001 M002 C001 32.663 " " 32.663 " " S002 M003 C002 45.66 " " 45.66 " " S002 M004 C002 28 mm 28 mm

Expected Output is Column Char1 and Char2. Kindly suggest how can I get above output in my target ? It's very urgent. Appreciate your help.

Thanks&Regards,

Foram Shah