Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
UKFan12
Frequent Visitor

Help with Splitting Columns

‎02-16-2023 11:56 AM

Hi There,

 

I used this code to split L52, L12 , L13, L4, but I couldn't get LW to also split. 

 

Any idea on what to type to make sure LW is kept in attribute 1 column while the other letters are moved to attribute 2 column?

 

UKFan12_0-1676589895958.png

UKFan12_1-1676589912779.png

 

 

 

 

 

Thanks!

 

 

Labels:
Message 1 of 4
563 Views
0
3 REPLIES 3
Padycosmos
Solution Sage
Solution Sage

‎02-17-2023 06:53 AM

Hope this helps:

https://blog.crossjoin.co.uk/2019/02/12/splitting-text-by-character-transition-power-bi-power-query-...

Message 4 of 4
473 Views
0
Padycosmos
Solution Sage
Solution Sage

‎02-16-2023 01:15 PM

Hope this helps:

Padycosmos_1-1676581906321.png

Padycosmos_2-1676581980651.png

Padycosmos_3-1676582062624.png

Padycosmos_4-1676582100956.png

 

 

 

 

Message 2 of 4
513 Views
0
UKFan12
Frequent Visitor
In response to Padycosmos

‎02-16-2023 04:37 PM

Sorry it is probably something I did wrong but this did not work. I changed my message up to hopefully be a little more clear. Thanks for the help!

Message 3 of 4
493 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All