Parsing Field Values in Load Statement

[karan_kn]

Parsing Field Values in Load Statement, could you please help us to extract specific values based on underscore 

Pick Node=1_4_5_6_8 from Fieldname

Fieldname	NewField
100254_AM96_Text_Greece_Euro_2589_AMT_Y	100254_Greece_Euro_2589_Y
100254_AM23_INT_India_Asia_578_AMT_H	100254_India_Asia_578_H
100254_AM56_Text_Japan_Asia_256987_AMT_Y	100254_Japan_Asia_256987_Y

[brunobertels · Accepted solution]

Hi 

try this 

subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',1)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',4)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',5)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',6)
&'_'&
subfield('100254_AM96_Text_Greece_Euro_2589_AMT_Y','_',8)

replace '100254_AM96_Text_Greece_Euro_2589_AMT_Y' by your fieldname