Regex parse product size in varied format (metric and imperial)

[GurcuK]

Hi All,

I'm trying to extract size information from a list of product description. I am trying Regex parse but getting nowhere as the data is not following a particular pattern, may include period, double quote, forward slash, "x" and space. I tried so many variations but just received part of the size or nothing. Any help would be very much appreciated

samples
GALV. SQ. TEES 161G 2x1/2
BLACK HWT FLAT-SEAT UNION C11B 1.1/2"
GALV. SQ. TEES 161G 1.1/2x1.1/4x1/2
YORKS STR CU-UNION/MI YP69 54mmx2" 08819

[binuacs · Accepted solution]

@GurcuK One way of doing this

[GurcuK]

thanks, this really helped!