i have a String column and need to extract values of it into multiple columns based on the name associated with it.
otherPartofString State DALLocate_SFO-4/3/9 sub Area=<8> ID 8 Name 7
the columns need to be formed from above are
State | Area | Sub Area | ID | Name DALLocate | SFO-4/3/9 | 8 | 8 | 7
any help is appreciated.