You can translate the question and the replies:

Denodo - extracting certain text from a field using regular expression

Hello Denodo Geeks, I am trying to extract certain text from a field in denodo using regular expression. To a certain extend I am able to acheive my target, but there a certain text values in the field that do not work as intented. Here is an example for better understanding. There is a field called 'Number of items' and the values are **1abc, 0.2abc , 0..3abc , .1abc, .1abc. ** I want to only extract all the numbers along with a single decimal point. Here is the regular expression I am using -regex(^\d+\.{0,1}\d*) in the regex tester webiste -https://regex101.com/ My thoughts are using Regexfind() , but it looks like denodo does not support this function.Any thoughts or leads are appreciated.!
Regular Expressions
user
02-05-2023 20:54:36 -0400
code

1 Answer

Hi, Regexfind() is not supported by Vitual DataPort, you can find all the supported Text Processing Functions from [here](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions). I would suggest to use a combination of these functions, for example, first replace all the alphabet value and then deal with the decimal point. Also you can open a new case in the [Denodo Support Site](https://support.denodo.com/MainPage.do) if you are a valid support account user, so the Denodo team can help you. Hope this helps!
Denodo Team
08-05-2023 06:54:09 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here