how to apply subfield function

[Anonymous]

hi all i have data like

india___AP-44967___TS-KA55786,MAIL

i want split the data new fields AP-44967 ,TS-KA55785 And mail

[Chanty4u]

try this

aa:

load *,SUBFIELD(text,'___',2)  as 1,

SUBFIELD(text,'___',3)  as 2,

SUBFIELD(text,',',4)  as 3  ;

load * Inline [

text

india___AP-44967___TS-KA55786,MAIL

];

exit Script;