Power Query: keep only specific syntax in a column

[Das443344]

Hello,

I have a column "serial numbers" full of much kind of words and numbers, like in this picture:

In the middle of this data, there are 1 or more serial numbers (in the picture above highlighted in yellow) that have always the same syntax xxx.xxx.xxx.xxxx.
I need to remove all other characters and keep only the serial numbers separated by a semicolon, like in this example:

Unfortunately as you can see there is no specific delimiter that i could use to extract only the string that has the syntax xxx.xxx.xxx.xxxx.

thanks!

 

[alansidman]

Please reload your sample data using XL2BB so that we don't have to reconstruct your data to test. See my signature for instructions.