hi fellow experts,
- i am working on a data conversion task and after 24hours of non-sleep, i'm unable to get my brain working on this. i have list of data as below in an Oracle table, and i need to extract the value in middle, in-between the two underscore '_'. the length can be vary:
- expected result:
- any method is welcome either using regular expression or substr-instr...