Different fields from one field

[smilingjohn]

HI All,

I have field called "Clubbed "( in this filed the data should be divided into 4 fields as it is separated by  dash (-) )

in which the information looks something like below .

Clubbed

PWD-A1-Train CC Reg -Railways

IND-B2-Group 3-Corruption

Sports-M2-Cricket-Ball

WI-C3-Dar1-Cosmatics

Now How do I convert  different fields   like  Department, Sect,Group and environment  I have posted my output  below 

how can we achieve this in script ? 

Department	Sect	Group	Environment
PWD	A1	Train CC Reg	Railways
IND	B2	Group 3	Corruption
Sports	M2	Cricket	Ball
WI	C3	Dar1	Cosmatics

Thanks in Advance 

[smilingjohn · Accepted solution]

Hi All,

I got it using subfield function 

Thanks