Skip to main content
Question

Can we convert text to numeric value in vsql?

  • September 12, 2023
  • 1 reply
  • 4 views

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!

kailash.potha12
Level 5
Forum|alt.badge.img+1

You can do it in ML Workbench

image


Reply