regular expression in oracle for including number and period

Question

I need regular expression for which will remove all Non numeric character excluding. means it only include Number perid (.)

can anybody help me.

Thank you. Vijay Nalawade

Answer 1

Try something like below:

     REGEXP_REPLACE('your text 12.133', '[^0-9\.]','')

This will delete all non numeric and non dot characters.

Please note: \ is required in front of . as . match any character. Details here: Oracle Regular Expression

Answer 2

Regex [0-9.] matches only digits and .. Alternatively you can find replace other characters with an empty string using this regex: [^0-9.]