Latest Activity

code

Read URL from reverse

Dear all, i need to parse the url and get the last part of the string. for example : https://community.denodo.com/answers/question/manage or https://community.denodo.com/answers/question/manage/ i need to read the part "manage" i was earlier ...

REGEXP_LIKE Regex URL substring string conversion

code

Question on Regular expression

Scenario One column is there with the name of d1 and its row value is : "The cookies of this site". I want the value of second word only("The cookies") not using INSTR/Substring but using regexp. I tried to select only two initial words using...

Regex

code

Split function in Denodo does not work! (second way) Regex for complex string in Denodo

I am basically trying to split the following string in Denodo and trying to create new columns in the database for each value. my_string = ABLMNC_154342_O_UW_UA-UCOU_SMC The problem i am facing is when i split the string, Denodo creates an arra...

Regex Split

code

Count the number of commas is a string

Is there a way to count the occurences of a comma in a string? I need to filter out any rows there there are NOT exactly 3 commas in that field.

Regex count

code

Remove duplicate words with a regular expressión

Hello: I have this input: abc,abc,123,000,123,000 And I need to remove duplicates words. The output must be: abc,123,000 I'm using this regexp: \b(\w+)\b\s,\s(?=.*\1) but it doesn't work. I'm testing in this page were works: https://regex101.com/r/...

Duplicates Regex

code

RegexExp to extract value between parentheses

I am trying to use the following formula to return the value that is between parentheses in a field. For some reason it is just returning the exact same value. I am pretty sure this REGEX is valid. regexp(bv_epic_tpi_inventory_report.hcco, '/(([^)]+)...

Formula Regex

code

regexp on a string of data between special characters

Hello, I have a data coming to a coloum as following, $kjsfdlesjfdflkdfche$ something. some more text $ornikvempo$ few more text I need to select the column to look as -- something. some more text few more text, basically I want to remove everything...

Regex