Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
543@456/456/334
I`m trying to skip the first delimiter and take out the first 6 numbers?
so I get 543456, is there a way to do this in one go?
my thinking is I might just have to first to extract everything before the @ into a new column.
Then run the operation again to extract everything before the / forward slash, to take those next 3 figures into a new column.
Then merge those 2 new columns.
Is this an M code situation?
Solved! Go to Solution.
Another alternative where Data is column name
Text.Start(Text.Select([Data],{"0".."9"}),6)
Text.Start(Text.Remove(your_text, "@"), 6)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
65 | |
62 | |
23 | |
18 | |
12 |