Dissect column to extract data attributes

building reports webintelligence
1

I have a field with ‘|’ delimiter and the designer used the following to set into each attribute field. The problem is nothing is getting returned?

example of the data stored in the source object
1004|1001|138|114222||N

His Script in Designer for extract the column(s) information is:

SUBSTR(Source_Column,
REGEXP_INSTR(Source_Column, ‘|’, 1, 2)+1,
REGEXP_INSTR(Source_Column, ‘|’, 1, 3)-
REGEXP_INSTR(Source Column, ‘|’, 1, 2)-1)

2

| is a special character
try to mask it with backslash oder double-backslash
\| or \\|

1 Like
3

Thanks, that was it… I still needed it to be within the quote(') but the DOUBLE slashes worked!

4

Can you mark @N8AKTIV’s answer as correct?