I'm currently using:
regexp_replace(ee.sku,' ?\([^)]+\)') as sku_cleansed
which makes the string before:
MC HDMIB 2m (6.56 ft.)
MC HDMIB 2m
Is there a way to further filter the "2m" - or anything matching: ##.##m ? I would also want to remove "12.4m" (and ft.).