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.
Good
I need help to know how I can extract in power query from a column that contains free text , which can have text figures or expecial characters every time a number of 10 digits is found that are followed . These 10 figures in a row can be in any position and are not accompanied by any index or similar.
An example would be this. My NEW COLUMN would only have to return me when in the free text column you find 10 numbers in a row
Is it possible to do it without knowing M, using in power query ?.. I have tried to do it by inserting column from examples but being so many different the possibilities do not find a pattern.
I know that in sql with the function REGEXP_EXTRACT(FREE_TEXT, "[0-9]{10}") it could be done, but I tried the same formula in power query without satisfactory results
Thanks in advance
Solved! Go to Solution.
Here is a similar solution for your reference, will it help?
Solved: Extract 5 Consecutive Numbers from Text String - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Here is a similar solution for your reference, will it help?
Solved: Extract 5 Consecutive Numbers from Text String - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |