We are looking for a solution that transform these underscore (_)
value strings into individual “name – value” pairs.The number of “_”
separated values in the concatenated string can also change over time
and need to be dynamically handled.We are looking to create a dynamic
code in C++.delimiter in the string and no of columns in the string are variable.
we will use this C++ code in netezza database as a function.
Source Column Value:dl_v5.2_2_9_1200_256_0_1_64_0_54_2345
below is the out put we expected.
P1 P6 P7 P8 P11
dl 256 0 1 54