I have values in a column like 90, 100, 30, sixty, nienty, six
Here I’m looking for a function/way we can convert sixty, nienty, six to 60, 90, 6
For now I’m using regular expression in case when to define the numeric value of text.
looking for more suggestions
Thanks in advance!