Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Got this using sub field function
Thanks