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 all,
Please could someone let me know how I can extract an 7 digit number that starts with a 1 from a column which contains other numbers (luckily of a different length or which don't start with a 1) and text. It would be great to separate this number and put it in to it's own column if that's possible.
Examples below. As you can see the 7 digit number appears in different places in the column.
1002223 - 7003117328 - ID: 74526 - Attendance |
1046890301 - 210438 1002515 - CW |
2047074788 - 210525-1002834 |
1053847149 - 1016727- 212170 - cw upper |
Many thanks in advance for any help.
Marcus
Solved! Go to Solution.
Understood - many thanks Darlove for pointing me in the right direction. Much appreciated.
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |