Hello,
Another question related to Column split. This time I would need to split data into 2 columns, where delimiter is last capital letter.
For instance:
Robert DuvallCrime
TabuDrama
Should be splitted as:
Thanks
Pepe
Another question related to Column split. This time I would need to split data into 2 columns, where delimiter is last capital letter.
For instance:
Robert DuvallCrime
TabuDrama
Should be splitted as:
Column1 | Column2 |
Robert Duvall | Crime |
Tabu | Drama |
Thanks
Pepe