Search filter not working for data type


I have created a repeating group in Bubble that requests data from an API. The API returns the following data fields: “Name” (text field) and “Height” i.e. 6-7 ft.

I am trying to use the slider input to search for a min/max height, however because of the “-” and the “ft” - bubble will only display data as text, and I can only search properly using slider because some of the fields say " 6-7ft" and some say “6-8ft” and if the user uses the slider to search for “5-9ft” - it should display both results, therefore I need to set the data fields as as numeric ranges.

Does anyone know how I can do this?

In your data table, set a min foot, and a max foot.