Forum Discussion
split name surname in separate column
Hi, I went to the forum, but I have not found anything that suits my case. I have a colum like this ( name and surname) MARCO DI BENEDETTO MICHELE DE ROBERTO I'd like to split into 2 separate col...
mangaus1111
Solution Sage
Solution SageOtherwise you can use the macro Text before and after Delimiter from here
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good function but don't separate correctly ;-/
If I use Text before delimiter on
MARCO DI BENEDETTO
I obtain
DI
instead of
DI BENEDETTO
😕
- mangaus1111
Hi Anonymous ,
see my solution in the pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0TPmFFEFXXd-Zn1?e=BeuR8g