Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 colum
name | surname |
MARCO | DI BENEDETTO |
MICHELE | DE ROBERTO |
If I split column by delimiters ( space) I obtain something wrong due to surname with 2 parts ( DI BENEDETTO)....
any idea is appreciated !
Thanks
Diego
Otherwise 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
😕
Hi @Anonymous ,
see my solution in the pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi0TPmFFEFXXd-Zn1?e=BeuR8g
Ciao Diego,
you can use this in Power Query:
For Surname
= Table.AddColumn(#"Inserted Text Length", "Text After Delimiter", each Text.AfterDelimiter([Name], " "), type text)
For Name
= Table.AddColumn(#"Removed Columns", "Text Before Delimiter", each Text.BeforeDelimiter([Name], " "), type text)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, on Power query right click on the column, split by delimiter and then choose "Left-most delimiter". KLL
Hi @Anonymous ,
This is my data:
You can create two calculated column:
Hope my answer could help you!
Ganger
Ehm, in your solution we lost part of surname (DI or DE), correct surnema is
DI BENEDETTO
DE ROBERTO
...that's my headache! 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |