Need help to get the 8 digit number from the given column, thanks.
|given column||extract 8 digit number|
Solved! Go to Solution.
i have a new problem
the numbers seperated by the text or delimiter were merged to form the 8 digit number, and i don't want this to happen
DATA what I have what I need
In power quey,click that column and there is option available called split column to extract the numbers from text.
If I answered your question,kindly mark it as solution.
|given column||By splitting||extract 8 digit number|
|what I have||what I need|
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.