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
