Different fields from one field

smilingjohn — Tue, 21 Dec 2021 17:54:31 GMT

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 ?

Thanks in Advance

Re: Different fields from one field

smilingjohn — Tue, 21 Dec 2021 19:02:06 GMT

Hi All,

I got it using subfield function

Thanks