Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
aa:
load *,SUBFIELD(text,'___',2) as 1,
SUBFIELD(text,'___',3) as 2,
SUBFIELD(text,',',4) as 3 ;
load * Inline [
text
];
exit Script;