Q&A BY TAG 'Split'

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

How to split a string at a delimiter
answered 17-05-2022 04:45:54 -0400

I have a string "India (IN)" I only want the country name India removing the delimiters and abbreviation (IN) Split function is not working.

Answers: 1


Convert CSV into rows without the use of SPLIT function
answered 07-01-2021 02:08:55 -0500

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.

Answers: 1

Delegate FLATTEN Split