The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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! 😉
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |