Q&A BY TAG 'Regex'

You must sign in to ask a question. If you do not have an account, you can register here

Split function in Denodo does not work! (second way) Regex for complex string in Denodo
answered 24-06-2022 09:23:14 -0400

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...

Answers: 4

Regex Split

Count the number of commas is a string
answered 31-03-2021 09:45:04 -0400

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.

Answers: 2

Regex count

Remove duplicate words with a regular expressión
answered 07-12-2020 07:38:34 -0500

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/...

Answers: 1

Duplicates Regex

RegexExp to extract value between parentheses
answered 28-09-2020 02:55:22 -0400

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, '/(([^)]+)...

Answers: 1

Formula Regex

regexp on a string of data between special characters
answered 13-11-2019 01:36:27 -0500

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...

Answers: 3