Split Concatenation and SQL

Summary:

Split Concatenation and SQL

Content (required):

Am processing rows using concatenated values where each segment is separated by an underscore character (_) Ex: A23_B11011_C13432_DEF1232 and it works fine if I use <1>, <2>, <3>, <4> for each of the 4 dim.

Source values can be A23_B11011_C13432_DEF1232, A23_B11012-C13432_NA_F1232 etc.. When it is A23_B11012-C13432_NA_F1232 where NA_F1232 is member name(default) of the 4th dimension(has a underscore in member name) and the <4> brings up only NA and not NA_F1232. Wherever I find members without underscore it needs to be loaded AS IS(DEF1232) and default to NA_F1232 otherwise