Extracting numbers from a string

[lagos-a1]

Hi, 

I am trying to extract the floor number from the following strings:

Input	Expected Output
1IFSCHK22.08COL@	22.08
1IFSCHK18.04Shared@	18.04
rm.9HUMATER9.16@	9.16
1IFSSCHK18.02RMGTSSEAM5paxVCAC@	18.02
9HUSSNTER9.09TEAM8paxV@	9.09
9CENTSRAL10.02TEAM8P@	10.02

Any thoughts?

[Felipe_Ribeir0 · Accepted solution]

Hi @lagos-a1 

You can use this formula

(\d{1,}\.\d{1,})