This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi I am wanting to split a string of text based on an integer and using the first space following an integer. This is a sample of the data.
B F 3 Exceed And Excel B G 5 Valixir(IRE) B OR BR F 3 Teofilo(IRE) BR OR BLK G 6 Fomalhaut(USA)
My desired result is
Exceed And Excel Valixir(IRE) Teofilo(IRE) Fomalhaut(USA)
I tried splitting on {"0".."9"} to represent any of an array of integers but that doesn't work. A little unsure of other tricks I could use.
Ideas?
Solved! Go to Solution.
Wow as soon as I posted I solved it. I used custom column from examples. Selected my current column and then supplied the example data and it was like flash fill in Excel it figured it out.
Wow as soon as I posted I solved it. I used custom column from examples. Selected my current column and then supplied the example data and it was like flash fill in Excel it figured it out.
@Anonymous,
Glad to hear that. You may share more complete solution here and accept it. Your contribution is highly appreciated.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 22 | |
| 20 |