how to apply subfield function

Anonymous — Tue, 31 Jul 2018 12:15:13 GMT

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

Re: how to apply subfield function

Chanty4u — Tue, 31 Jul 2018 15:34:55 GMT

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;